Default Date Format

G

Guest

Currently when I use the (CTRL-SHFT-#) keyboard shortcut on a number in Excel
2003, it formats it as dd-mmm-yy. Is there a way to change that format? If
so, where do I need to go to do it?
 
S

Stephen Bye

Start > Control Panel > Regional and Language Options > Regional Options >
Customize > Date > Short date format
 
G

Guest

The Regional & Language Dialog box in control Panel has the short date as
(mm/dd/yyyy), 10/9/2006 So it would seem that something else is controlling
the Excel (CTROL-SHFT-#) which is still showing it as 9-Oct-06
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting a number as a date 1
Date Format 1
Wrong date format in header 1
Incrementing dates in the format MMM-YY 3
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
TextBox will not clear date??????????? 4
date format - excluding year 2
Date format in VBA 4

Top