| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| Telephone number format | Excel Discussion (Misc queries) | |||
| how to change the h:mm format to number? | Excel Worksheet Functions | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
