Sep 29 2021 10:40 AM
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?
Sep 29 2021 11:15 AM - edited Sep 29 2021 11:16 AM
DATEVALUE(YourTextDate) then format it as YYYY (shortcut CTRL+1)
or
Text(DATEVALUE(YourTextDate),"yyyy")
Sep 30 2021 01:37 PM
SolutionThank 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
Sep 30 2021 01:37 PM
SolutionThank 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