LinkBack URL
About LinkBacks
Hi All,
Pls see attached relevent file.
i need to transfer column D to normal date (MM/DD/YYYY).
I have tried to use left/right function. however, the excel doesn't read it as a date cell.
I'll appricaite any help,
Thanks
Hi All,
Pls see attached relevent file.
i need to transfer column D to normal date (MM/DD/YYYY).
I have tried to use left/right function. however, the excel doesn't read it as a date cell.
I'll appricaite any help,
Thanks
In E2 and copy down:Formula:
Please Login or Register to view this content.
BSB
I read this as a formatting question - could you please confirm?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
This worked for me...
Select the range of dates
Goto the Data tab>Text to Columns
Click Next twice
In Step 3 of the userform, under Column data format, select Date
In the drop down list select YMD
Click Finish
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks