Hello, I hope you can help me with the subject below.
I have 700 cell with dates in this format: '27102016'
But I need them in this format: 27/10/2016
What would be the fastest way to change all of them?
Thank you!
Hello, I hope you can help me with the subject below.
I have 700 cell with dates in this format: '27102016'
But I need them in this format: 27/10/2016
What would be the fastest way to change all of them?
Thank you!
You might try Data - Text To Columns
Choose Deliminated - Next
UnCheck all Options
Next
Select Date - DMY
Click Finish.
Hi lps,
With your 27102016 in F4, put this formula in G4.
=LEFT(F4,2)&"/"&MID(F4,3,2)&"/"&RIGHT(F4,4)
Is that what you want?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you very much, it worked.
I had to choose a text delimitation as ', but great advice overall.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks