|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 18th, 2005, 03:03 PM
|
|||
|
|||
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
March 18th, 2005, 05:36 PM
|
|||
|
|||
|
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
March 18th, 2005, 06:51 PM
|
|||
|
|||
|
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
March 18th, 2005, 06:57 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do i change numbers in text format to number format? | Greg | New Users | 1 | December 14th, 2004 05:22 PM |
| number format change within a document | NumbersPuzzle | Page Layout | 1 | November 16th, 2004 11:44 PM |
| Singe Precision field with currency format | Bailey | General Discussion | 1 | August 13th, 2004 05:00 AM |
| Change Email Format On Reply or Forward | Kevin | General Discussion | 2 | July 15th, 2004 10:47 AM |
| Automatically change number format | Melanie | Setting up and Configuration | 1 | March 27th, 2004 04:28 AM |
Linear Mode
