Your dates are text looking like dates. Correct this with Text2Columns
1. select teh range
2. click data tab/T2C
3. click next/next/select Date and chose your format
4. click OK
Your dates are text looking like dates. Correct this with Text2Columns
1. select teh range
2. click data tab/T2C
3. click next/next/select Date and chose your format
4. click 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
...it worked. WAT. But can you explain why on earth it was still registering the format of Column F as "Text" even though I had selected "Date"???? Why would it do that to me?![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks