| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formats default to dates
I have a user that every time he opens a workbook, the columns that were
numbers default to dates, he changes the format back to number & saves. Then when he opens it again its back to dates - where is the setting that is defaulting the cell format to dates? Thanks -- PaulaK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number formats default to dates
"PaulaK" wrote: I have a user that every time he opens a workbook, the columns that were numbers default to dates, he changes the format back to number & saves. Then when he opens it again its back to dates - where is the setting that is defaulting the cell format to dates? Thanks -- PaulaK This is happening to some of my users too. Will be interested in the solution. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| General number formats changing to Dates or Euros | Excel Discussion (Misc queries) | |||
| Default number formats for pivot table fields | Excel Discussion (Misc queries) | |||
| Excel should allow me to change default number formats | Excel Discussion (Misc queries) | |||
| number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
| Default column formats | Excel Discussion (Misc queries) | |||
Linear Mode
