I have been an Excel user for many years and feel very comfortable with it. I recently did a clean install of my OS (Win XP) and reinstalled Office 2007 - all good.
When using one of my Excel spreadsheets I notice that the date column no longer converts my date input to a Date format. I used to put in 23/11 and that would be converted to 23/11/13 on leaving the cell. I have tried reformatting to the Date format I want and even tried again in a new workbook. What have I missed?
Last edited by Arnold_G; 11-25-2013 at 01:23 AM.
Hi and welcome to the forum
Seeing as how you did a new OS install (as well as Office) have you set your regional dates yet?
I am in the US, and if I enter 11/23, i get 11/23/13. But if I enter 23/11, I get just that...23/11, because my regional date is not set up that way
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you FDibbins. You're a star.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks