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
 
Back
Top