Morning all,
I've been asked by a chap in our office about exported data in Excel. He's exported his activities into excel but the dates appear to be in Lotus format having a ' at the start of the date making calculation difficult and also including the time. Does anyone know if there's a setting I've missed to allow him to do it so it's in normal excel date format?
thanks in advance,
Thom
Update - I've been reading a lot of similar posts but they all seem to end with someone suggesting the replace command which unfortunately claims Excel can't find ' on the item that needs changing.
thanks