LinkBack URL
About LinkBacks
Just do a find...replace changing . to / and they should convert to serial dates.
Dom
Just do a find...replace changing . to / and they should convert to serial dates.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Try using "Text to columns"
Select column of dates
Data > text to columns > Next > Next > under "column data format" select "Date" and "DMY" > Finish
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks