Hello everyone,
I have a problem with some date in a workbook.
Their format do not update automatically, i have to double click to the cells and then pass to the next one to have the format i want,
the problem is, there are more than 2000 cells and i don't want to do it manually,
i tried few macro but none of them is working.
Does someone can help me please.
Formatissue.xlsx
the data from A29 down is not dates, it is text that looks like a date (test with =isnumber(A29) FALSE = text)
to fix this, highlight all that data, select Text2Columns, next/next/click on DATE and OK
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
I was sure i already tried that...
CAM ON
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
DamienR 
Register To Reply
Bookmarks