Hi
I have a sheet that needs to be saved as a .csv file to be read by another program.
I have 2 columns that need to be formatted as number with 2 decimal places eg 101.20
but when it's saved as a .csv it loses the formatting and becomes 101.2 (now I know this is the same number, but the other program needs the extra zero to still show and be saved as a number format)
is this just something that can't be done because of the .csv file?
thanks
Bookmarks