My dates format list is missing '/' separator. How can I restore.

  • Thread starter Thread starter GES in Oregon
  • Start date Start date
G

GES in Oregon

My copy of Excel 2007 has lost the '/' date separator function, including the
'.' instead. How can I get the slash mark option back?
 
Select the cells to format
Right-click
Choose Format Cells
Choose Custom
Enter mm/dd/yyyy as the format...
 
The short date format setting is found in Windows Regional and Language
Options.

Make the change there.


Gord Dibben MS Excel MVP

On Wed, 29 Oct 2008 20:02:06 -0700, GES in Oregon <GES in
 
You must log in or register to reply here.

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

Date format problem 7
names dates & amounts stated multiple times in document 0
Separate Day and Time from a Date Field 5
Dynamic Date Drop-down List 3
Data Validation List Names 2
The SEARCH function and parsing data 2
Adding days to a date - changed in Excel 2010 8
Date conversion 2

Back
Top