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
 

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

Excel does not accept text format! 0
Date Formats 4
How can I install Publisher in 365 Enterprise? 1
I have lost 6 months work, how can i get my file back 1
Exhibits 1
OneNote backups 0
MS Project 2016 - all tasks not showing in Calendar View 0
Merging Book Lists That Are In Different Formats 1

Top