Can I suggest that you do click teh diamond? 1st, highlight the entire range, then scroll to the top (so the range stays selected), then click the diamond and follow the steps, select 20xx if your dates are 20??I do not click on the little diamond at all. F2+Enter fixes them automatically.
Also I noticed sometimes it just shows the Diamond with date question if it is 20xx or 19xx. Is there a default to set all 2 digit years to recognize as 20xx?
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
Thanks for the info, I am using the diamond right now after pasting plain text, then in some cases I have to copy and paste special "formats" to fix this, however I see that Diamond comes back again, and this time asking me to select year indicator again xx/xx/20xx or xx/xx/19xx.
Is there anywhere in Excel I can specify that all dates be xx/xx/20xx?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks