Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defaulting to date format
Up until a few weeks ago all was well with Excel07. Then it started to
change the default number format to a date format. When I import a file to excel or do a copy paste, excel automatically formats numbers as dates. Suggestion was to create a template and save in xlstart but then everything will be formated as general. why did excel stop automatically detecting number formats? how can I change the default settings? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is defaulting to Number format instead of General format | Excel Discussion (Misc queries) | |||
I type in 1-2, how can I keep that from defaulting to a date? | Excel Discussion (Misc queries) | |||
Excel defaulting to 3 decimal places when using the gen. format | Excel Discussion (Misc queries) | |||
formula for filtering and a defaulting date | Excel Worksheet Functions | |||
Date Defaulting | Excel Worksheet Functions |