Is there really no easier way to get rid of the apostrophe in exported Date:Time cells? I've tried replace, but can't get Excel to search anything but formulas. Do we really have to use Paste Special Values (couldn't get to work) or Text to Cols? Isn't there a simple way to do this oft-encountered task?
I see no apostrophes, but I do see date times that are stored as text.
=D3+0
in an empty column, copied down, formatting as required will fix that.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
How are you importing the data to Excel?
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks