LinkBack URL
About LinkBacks
I have a column that contains dates in the format of 20080119 (Jan 19, 2008). How can I convert the values in that column to the format of 01/19/2008?
I have a column that contains dates in the format of 20080119 (Jan 19, 2008). How can I convert the values in that column to the format of 01/19/2008?
select column then use data/text to columns
click next/next
check date and choose ymd option
click finish
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That did the trick. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks