| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format of Cells Changing on thier own
Hi,
I use spreadsheets daily and for months now I have been having an issue where all my cells that are formatted as 'General' change themselves to 'Currency' when I reopen the spreadsheet. Does anyone have any idea why this happens or what I can do to stop it. Thanks. P.S all of the workbooks are saved on a server and the problem is happening on anyones PC who opens them. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format of Cells Changing on thier own
Maybe there's a macro that's changing the Normal style.
If you close excel and restart it in safe mode (to disable macros), do you have the same problem? Close excel windows start button|run excel /safe file|open your offending workbook GCC wrote: Hi, I use spreadsheets daily and for months now I have been having an issue where all my cells that are formatted as 'General' change themselves to 'Currency' when I reopen the spreadsheet. Does anyone have any idea why this happens or what I can do to stop it. Thanks. P.S all of the workbooks are saved on a server and the problem is happening on anyones PC who opens them. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I refresh cells after changing the format? | Excel Discussion (Misc queries) | |||
| How do I write a macro that will allow users to set thier own pass | Excel Worksheet Functions | |||
| Changing a cells format (Time) | Excel Discussion (Misc queries) | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) | |||
Linear Mode
