I have tried saving and closing and just saving the file, always as a .xls
file and it still converts to numbers.
"Dave Peterson" wrote:
Are you actually closing and reopening your file?
If you are, how are you saving your workbook--as a .xls ("Microsoft Office Excel
Workbook (*.xls)"?
It kind of sounds like you're saving as a .csv (comma separated values) file.
This type of file is plain text and won't preserve the formatting when you
reopen it.
Cassie wrote:
every time I format a column in the currency format and save, when I go back
to that column, the formatting has changed to number format. How can I get
this format to stay?
--
Dave Peterson
|