Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell changes format upon saving file
The numeric cells in a spreadsheet are formatted as numbers with 0-3
decimals. I save the spreadsheet and exit the program. Next time in, when I load the spreadsheet the formats of these cells have changed to date formats. Can anyone help me with why this is happening and how to correct it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell changes format upon saving file
What type of file do your have XLS or CSV. If it is CSV then it will not
preserve the formating. Try saving the CSV file using SAVEAS and save the file. Then always open the XLS file. "victorsm" wrote: The numeric cells in a spreadsheet are formatted as numbers with 0-3 decimals. I save the spreadsheet and exit the program. Next time in, when I load the spreadsheet the formats of these cells have changed to date formats. Can anyone help me with why this is happening and how to correct it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell changes format upon saving file
I am using Excel 2007 and the spreadsheet is of filetype .xlsx
"Joel" wrote: What type of file do your have XLS or CSV. If it is CSV then it will not preserve the formating. Try saving the CSV file using SAVEAS and save the file. Then always open the XLS file. "victorsm" wrote: The numeric cells in a spreadsheet are formatted as numbers with 0-3 decimals. I save the spreadsheet and exit the program. Next time in, when I load the spreadsheet the formats of these cells have changed to date formats. Can anyone help me with why this is happening and how to correct it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell changes format upon saving file
Check out
http://www.microsoft.com/office/comm...2fsettings.xml I still don't know how this setting got changed, but I suspect that one of my users is making this change without realizing the extent of it's effect. -rakudave "victorsm" wrote: I am using Excel 2007 and the spreadsheet is of filetype .xlsx "Joel" wrote: What type of file do your have XLS or CSV. If it is CSV then it will not preserve the formating. Try saving the CSV file using SAVEAS and save the file. Then always open the XLS file. "victorsm" wrote: The numeric cells in a spreadsheet are formatted as numbers with 0-3 decimals. I save the spreadsheet and exit the program. Next time in, when I load the spreadsheet the formats of these cells have changed to date formats. Can anyone help me with why this is happening and how to correct it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel file in DBase IV format | Excel Discussion (Misc queries) | |||
Saving file in CSV format | Excel Discussion (Misc queries) | |||
When saving CSV excel always prompts about the file format | Excel Discussion (Misc queries) | |||
Saving file in the format "YYMM" | Excel Discussion (Misc queries) | |||
how do i disable warning when saving file in csv format? | Excel Discussion (Misc queries) |