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 to another sheet because there showing another numbers totally different digits
Anybody knw pls help me
Now i using MS excel 13
Eg:- Date 12-12-2021 i need to covert this date to numbers, like 12122021
I used custom format but i can’t copy to another sheet because there showing another numbers totally different digits
Anybody knw pls help me
Now i using MS excel 13
3 Replies
- 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" Let's say your dates are in D2 and down.
In another cell in row 2, enter the formula
=TEXT(D2,"ddmmyyyy")
This assumes that you use D/M/Y as system date format. If you use M/D/Y, use
=TEXT(D2,"mmddyyyy")
Fill down.
- Try =--TEXT(A1,"mmddyyyy")
