Date Format Changes

K

KenG

Hello and thanks in advance. I have a situation where I enter the Date
format as
06/07/07. Then the next or a couple of days later I open the file and the
Date format has changed ex: 06/07/2007. Is happens on evey file that I have
with the date format in the sheet. I did try one thing so far, which was to
change the Date format in the Control Panel, Regional Settings for the "Short
Date" format to xx/xx/xx instead of xx/xx/xxxx.

Any links or feedback would be greatly appreciated.

KenJG
 

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

Top