ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date Format Changes (https://www.excelbanter.com/excel-discussion-misc-queries/145664-date-format-changes.html)

KenG

Date Format Changes
 
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


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com