K
Karen Thomas
We are having problems saving excel spreadsheets to .csv files. It
appears that .csv files will only use the format cells > number >
general format, and we are losing decimal places of data. It appears
to be arbitary, but I know that can't be true. If we change the
format cells > number to number with 2 decimal places, we see that the
decimals are not really gone, just not visible. When we transfer data
from the .csv file to database tables the truncated, or sometimes
rounded?, data is lost.
Help!
appears that .csv files will only use the format cells > number >
general format, and we are losing decimal places of data. It appears
to be arbitary, but I know that can't be true. If we change the
format cells > number to number with 2 decimal places, we see that the
decimals are not really gone, just not visible. When we transfer data
from the .csv file to database tables the truncated, or sometimes
rounded?, data is lost.
Help!