G GES in Oregon Oct 30, 2008 #1 My copy of Excel 2007 has lost the '/' date separator function, including the '.' instead. How can I get the slash mark option back?
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 Oct 30, 2008 #2 Select the cells to format Right-click Choose Format Cells Choose Custom Enter mm/dd/yyyy as the format...
Select the cells to format Right-click Choose Format Cells Choose Custom Enter mm/dd/yyyy as the format...
G Gord Dibben Oct 30, 2008 #3 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
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