Trailing zero in Excel

[kabushnell]

When in Excel I am trying to get a third decimal place, which is always a zero to stay in the format of a column. I am saving the file as a .csv to use as an import. The number example is 8010.020. Is there a way to keep this third decimal place. Simply formatting the column doesn't seem to work as the actual value of the cell is 8010.02.

 

[eyec]

under Tools - Options - Calculations
click the box for "presicion as displayed"

you will get a popup that tells you "you will lose acuracy" or something like that but if your values are already calculated they will not change.