Data format in publisher merge function

[DK]

I am trying to merge data from excel to Publisher and some columns of data
come across with too many decimal position i.e number in excel 54.090 comes
across as 54.09000000003. I have tried to format the columns as text but does
not seem to work.

 

[Ed Bennett]

I am trying to merge data from excel to Publisher and some columns of
data come across with too many decimal position i.e number in excel
54.090 comes across as 54.09000000003. I have tried to format the
columns as text but does not seem to work.

Export your Excel file as a CSV file and merge from that.

 

[Martin]

If you are using Excel as your data source document I recommend taking the
series of cells that are causing troubles and using the "FIXED" function to
set them to the desired number of decimal places. It worked for me.