Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date auto correct
I have two problems with regards to date auto correct:
1) when i enter 4/6 - ie 4 June as i want ddmmyyyy - it automatically changes to 06-Apr when i actually want 04-Jun. I have looked through all the options i can find and changed defaults to yyyymmdd (although i would like is at ddmmyyy, but that is not an option on the list). 2) secondly i sometimes need to have a cell that says 3/4 or 1/2 without it automatically chaging this to a date. how do i switch this off? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto correct in excel | Excel Discussion (Misc queries) | |||
Annoying Auto correct | New Users to Excel | |||
How do I turn off auto correct? | Excel Discussion (Misc queries) | |||
Auto Correct ? | Excel Discussion (Misc queries) | |||
auto correct | Excel Discussion (Misc queries) |