Date format

B

Basharat Javaid

The date format keeps changing when we transfer excel files over the network
from my boss' computer to the other two computers. On his computer, it will
be in the format MM/DD/YY, and when it is transferred, the date changes to
M/D/YYYY. How do we fix this to display the date in MM/DD/YY on all our
computers?
 
G

Guest

In Control Panel > Regional and Language Options>Customize you can set the
short date formats as m/d/yy or mm/dd/yy or m/d/yyyy or mm/dd/yyyy. You
should decide which you want to use and set them to match.
 
B

Basharat Javaid

Why shouldn't the date format setting in MS Excel override the setting in
Control Panel pertaining to the date format?

Charlie
 

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

Preserving date format 1
date format 1
Weird date format problem 2
Excel 2002: How to make the date format uniform ? 1
WHY DOES DATE FORMAT CHANGE IN COLUMN 1
Date Format Not Responding to MM/DD/YY 2
Date format 4
Conditional formatting of date-cell - 2007 5

Top