why does currency format change to number format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
I have tried saving and closing and just saving the file, always as a .xls
file and it still converts to numbers.
 
Back
Top