Column Date Format

J

Jerry

Problem Description: Something has happened to my ability to change the date
format in Excel 2003 Professional. Previously to this incident I could type
in 03/17/09, then change the format of the cell in the ("format cells) dialog
box to "format cells" to 03-Mar-09 in the dropdown and it would appear as
03-Mar-09.
Also if I type a date in the column NOW and click on Format Cells> select
date> when I click the various formats that are available, the "sample" in
the dialog box does not change.
Apparently the ability to change the date format is gone, but I have no idea
why.
I've tried using the disc to perform an Office Repair - No Help
I've unzipped the file (Excel)from the disc to run excel as a new program -
No Help
 
G

Gord Dibben

Perhaps you changed your Windows Regional and Language Options and now
03/17/09 is not recognized as a date?

What happens if you type 17/03/09


Gord Dibben MS Excel MVP
 

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

Top