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

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?
 
S

Sheeloo

Select the cells to format
Right-click
Choose Format Cells
Choose Custom
Enter mm/dd/yyyy as the format...
 
G

Gord Dibben

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
 
Top