Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Entry
Excel 2007, Vista Business, US English.
I was able to use Ctrl+; with cells formatted dd/mmm in Excel 2003 and the result was e.go. 14/May. Now with similar cell formatting I get 14/5/2007 when I use the Ctrl+; Does anyone know what is going on? TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Entry
Hi Daniel,
The difference is your cell formatting before using Ctrl+; The 14/May would have a cell format of dd/mmm but the 14/5/2007 probably had a default cell format of General the entry is a date so it used your short regional date format the probably looks like d/m/yyyy in your Control Panel, Dates For more information on Date and Time see http://www.mvps.org/dmcritchie/excel/datetime.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Daniel L. Lieberman" wrote in message ... Excel 2007, Vista Business, US English. I was able to use Ctrl+; with cells formatted dd/mmm in Excel 2003 and the result was e.go. 14/May. Now with similar cell formatting I get 14/5/2007 when I use the Ctrl+; Does anyone know what is going on? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restricting date entry relative to current date | Excel Worksheet Functions | |||
Date entry | Excel Discussion (Misc queries) | |||
date entry | Excel Discussion (Misc queries) | |||
last entry of a particular date | Excel Discussion (Misc queries) | |||
Date entry | Excel Discussion (Misc queries) |