Forum Discussion
Converting a Text Date with 4 digit year to Date
I have a list of text formatted dates with 4 digit years and no 0 padding, that I need converted to dates preserving the 4 digit year and non-0 padding. Any suggestions?
Thank you so much Juliano! I managed to find a quick cheat by:
1. Copying the entire column of "dates"
2. Opening and pasting into Notepad
3. Reformatting the column to text
4. Copying and pasting from Notepad back to the column and pasting as "value"
Cheers,
Larry
2 Replies
DATEVALUE(YourTextDate) then format it as YYYY (shortcut CTRL+1)
or
Text(DATEVALUE(YourTextDate),"yyyy")
Thank you so much Juliano! I managed to find a quick cheat by:
1. Copying the entire column of "dates"
2. Opening and pasting into Notepad
3. Reformatting the column to text
4. Copying and pasting from Notepad back to the column and pasting as "value"
Cheers,
Larry
