Forum Discussion
Vineeth_Surendran
Feb 07, 2022Copper Contributor
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 ...
HansVogelaar
Feb 07, 2022MVP
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.