inputting date - UK version

Microsoft Excel 2003 (full product)
November 1, 2009 at 10:53:37
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: inputting date - UK version

Report •

November 1, 2009 at 12:25:02
Wrong forum - Post in the Office Software forum.

Report •
Related Solutions

Ask Question