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?
--
Charlie Graham

In Control Panel Regional and Language OptionsCustomize 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.

"Basharat Javaid" wrote:

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?
--
Charlie Graham

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

Charlie

"JLGWhiz" wrote in message
...
In Control Panel Regional and Language OptionsCustomize 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.

"Basharat Javaid" wrote:

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?
--
Charlie Graham