| 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) | |||
Hybrid Mode
