Combining date to one cell with uniform results

G

Gail

I am trying to remove the / from a date column and have the results formated
equally. For instance, the original column has various dates fromatted
different ways such as, 3/8/1955 or 10/05/1985. I need a column with the
dates displayed with 6 numbers 03081955 and 10051985
Any help would be appreciated.
 
D

dhstein

=IF(MONTH(G24)<10,"0"&MONTH(G24),MONTH(G24))&IF(DAY(G24)<10,"0"&DAY(G24),DAY(G24))&YEAR(G24)
 
D

David Biddulph

If they are real dates, not text, format the cells as ddmmyyyy or use
=TEXT(A2,"ddmmyyyy")
 
Top