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

My copy of Excel 2007 has lost the '/' date separator function, including the
'.' instead. How can I get the slash mark option back?

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

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


"GES in Oregon" wrote:

My copy of Excel 2007 has lost the '/' date separator function, including the
'.' instead. How can I get the slash mark option back?

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

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
wrote:

My copy of Excel 2007 has lost the '/' date separator function, including the
'.' instead. How can I get the slash mark option back?