Hi,
I need to convert the date format dd/mm/yyyy to yyyymmdd.
How would I go by?
TIA
Ana
Hi,
I need to convert the date format dd/mm/yyyy to yyyymmdd.
How would I go by?
TIA
Ana
Assuming A1 contains your date.
=TEXT(A1,"yyyymmdd")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks