why does currency format change to number format?
 

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.



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

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

Sorry, I don't have another guess.

Cassie wrote:

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


--

Dave Peterson