LinkBack URL
About LinkBacks
I have the attached list of dates. I need to add the full four numbers so 01 would change to 2001 and 97 would change to 1997. Does excel have a function to do this with?
I have the attached list of dates. I need to add the full four numbers so 01 would change to 2001 and 97 would change to 1997. Does excel have a function to do this with?
Can you post some examples?
You mentioned an attachment, but I don't see it.
I think it would be more accurate if you know the earliest year in your database.
Here is a formula that should do the conversion. It breaks at half of the century but it can be adjusted to the earlier date.
Formula:
Please Login or Register to view this content.
v A B 1 01 2001 2 05 2005 3 97 1997 4 16 2016 5 17 2017 6 12 2012
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
that's perfectOriginally Posted by AlKey
I think it would be more accurate if you know the earliest year in your database.
Here is a formula that should do the conversion. It breaks at half of the century but it can be adjusted to the earlier date.
Formula:Please Login or Register to view this content.
v A B 1 01 2001 2 05 2005 3 97 1997 4 16 2016 5 17 2017 6 12 2012
Select the range having dates. Format cells.
Format cells --> Date -->Select the required format showing four digits for year.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks