Importing from excel - calculations

[rburns77]

Having problems with repetitve numbers when importing an .xlsx file into FMP 10.

In my excel file, I have a field that shows only 2 numbers after the decimal, but when I import it into FMP, it has repeating numbers after the decimal.

I have figured out how to make it show only 2 digits in the field that it is importing into.

However, I have a calcualation that includes this field and the returning number for the calculation is showing repeating numbers after the decimal. I have changed the number of repetitions in the options to 1, and it still repeats.

Any ideas?

[comment]

I am not sure what you mean by "repeating numbers after the decimal", and what do repetitions have to do with it. It sounds like the imported data has more decimal digits than Excel shows (due to cell formatting). This is carried over to the calculation - IMHO, correctly so, since you probably don't want to lose the extra precision.

You can format the calculation result to display a fixed number of decimal digits, or you can tell the calculation to round the result permanently.

[rburns77]

rounding! Why didn't I think of that? Duh!