Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut Date entry problem
In the past by using ctrl+; I have been able to, using formatted cells show
e.go. 14 Mar. All of a sudden I cannot. What I get is 14-03-2007. My short date is set in Regional Settings as dMMMyy. Vista Business and Excel 2007. TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut Date entry problem
Right click Format cells Custom d mmm
"Daniel L. Lieberman" wrote: In the past by using ctrl+; I have been able to, using formatted cells show e.go. 14 Mar. All of a sudden I cannot. What I get is 14-03-2007. My short date is set in Regional Settings as dMMMyy. Vista Business and Excel 2007. TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut Date entry problem
Sorry it doesn't work. The problem appears to have started in the keyboard
shortcut Ctrl + ; The regional settings are correct but while the date is proper there the formatting in Excel doesn't work. "Teethless mama" wrote in message ... Right click Format cells Custom d mmm "Daniel L. Lieberman" wrote: In the past by using ctrl+; I have been able to, using formatted cells show e.go. 14 Mar. All of a sudden I cannot. What I get is 14-03-2007. My short date is set in Regional Settings as dMMMyy. Vista Business and Excel 2007. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data entry problem | Excel Worksheet Functions | |||
shortcut to last entry in a column | Excel Worksheet Functions | |||
Data Entry problem | Excel Discussion (Misc queries) | |||
Data Entry problem | Excel Discussion (Misc queries) | |||
Double entry problem | Excel Discussion (Misc queries) |