Formatting problem - numeric or not?

[datanibbler]

Hi,

I have the following problem:

- From one file, I get a ready-made figure (which is cost_per_minute), that is numeric and has 4 decimals.

- From another file, I have - actually the same figure, cost_per_minute.

<=> My problem is, that second figure has 8 decimals and I want only 4 - I need to re-do a calculation like our customer

       has done it with 4 decimals, so I need to avoid rounding errors.

<=> For some reason, I can't seem to be able to format that with just 4 decimals.

I can attach the Excel_file that I use to get the second figure (it's the last line; It has 8 decimals like I said, though it's now formatted with 4; I need just 4); The first one, which has just 4 decimals, is below in the same file.

=> I want to concatenate both those figures in one table.

Can anyone help me do that?

Thanks a lot!

Best regards,

DataNibbler

[datanibbler · Accepted solution]

Okay,

I have made it now. Excel has strange ways ...

I used round() with the required starting_value in the end. I've no idea, though, why that worked now and num() didn't work.