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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date auto correct
Hi
It sounds as though your Regional Setting are set to US rather than UK Control PanelRegional SettingsChoose UK AS for the second part of your question, either pre-format the cell as Text before entering 3/4 or place a single quote in front of the entry '3/4. The quote won't show up in the cell, but it will force the entry to be text. -- Regards Roger Govier "m.beebee" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date auto correct
Hi,
I think you might need to go to control panel and check the regional settings are set to the UK date format when typing 1/2 what do you mean, a half or 1 out of two? the best thing is to put a ' before it when you type it "m.beebee" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date auto correct
Thanks. I had it set on English-South Africa, and everyone i know here uses
the UK date format, so i assumed that excel would be the same. yeah, i found that if i put a letter infront then it is cool. What i have is a column that says - 'K-rating' and then it will either be a number such as 1, 2, 3, 4, etc or it will be 1/2, 2/3, 3/4. Problem is it automatically changes those into a date. so I now just put in K2/3 or K3/4 but thanks for your input. much appreciated. "Roger Govier" wrote: Hi It sounds as though your Regional Setting are set to US rather than UK Control PanelRegional SettingsChoose UK AS for the second part of your question, either pre-format the cell as Text before entering 3/4 or place a single quote in front of the entry '3/4. The quote won't show up in the cell, but it will force the entry to be text. -- Regards Roger Govier "m.beebee" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
date auto correct
Thanks a mil. I have it set on English South Africa. we use the same date
format here. wrt the other item, the column needs to have either a number 1 - 5, text or 1/2 or 3/4 or 4/5 or 2/3 you get the idea. It is used as a rating - so i just put a K infront of it. "DazzaData" wrote: Hi, I think you might need to go to control panel and check the regional settings are set to the UK date format when typing 1/2 what do you mean, a half or 1 out of two? the best thing is to put a ' before it when you type it "m.beebee" wrote: 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
date auto correct
Format the cell as fraction (up to 1 digit), or custom # ?/?
-- David Biddulph "m.beebee" wrote in message ... .... 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? |
Reply |
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) |