Entering dates in Excel

Microsoft Excel 2003 (full product)
November 1, 2009 at 12:38:43
Specs: Windows XP
Hi. There is a common problem with dates in xcel spreadsheets between Amercan and UK formats (mm-dd-yyyy vs dd-mm-yyyy). I want the latter, but no matter what I do - to change the locale in the number tab, under dates, it always reverts to "mm-dd", if I was to, say, type "2-11[ENTER]" to try and have it come up as 2-Nov.



See More: Entering dates in Excel

Report •


#1
November 1, 2009 at 14:34:20
First change the Windows settings.

Control Panel
Regional Language and Options
Select English United Kingdom

Make sure the Short Dates and Long Dates are in the correct format.

Then on the Excel Task Bar
Format
Cell
Numbers Tab
Custom

Replace the word General with:

dd-mmm

You need the third m to have it spell out the short month and four m's for the complete spelling.

MIKE

http://www.skeptic.com/


Report •

#2
November 1, 2009 at 15:37:18
Brilliant. Thanks Mike - I did a system restore on my computer, so it was the region language options that needed changing.


Report •

#3
November 1, 2009 at 16:59:53
Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question