I enter a date such as 7/8/2010 but when I save it it reverts to 8 July, how can I keep the format I entered?
Thanks, Bob
I enter a date such as 7/8/2010 but when I save it it reverts to 8 July, how can I keep the format I entered?
Thanks, Bob
click the cell and format it to the date format of your choice. Format - Cells - Date
Hi Bob,
Welcome to the forum, check what your format for regional Settings are in Windows > Control Panel
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks