Forum Discussion
Date format convert to number formate
I want to convert date to number format., I tried several ways but i can’t convert it Eg:- Date 12-12-2021 i need to covert this date to numbers, like 12122021 I used custom format but i can’t copy ...
You can use =TEXT(cell,"MMDDYYYY") to force that date into text of that format
If you then need it to still be a NUMBER then add VALUE so you have =VALUE(TEXT(cell,"MMDDYYYY"))
BTW being in the USA, I used month-day-year format but if you use day-month-year then use "DDMMYYYY"
If you then need it to still be a NUMBER then add VALUE so you have =VALUE(TEXT(cell,"MMDDYYYY"))
BTW being in the USA, I used month-day-year format but if you use day-month-year then use "DDMMYYYY"