Combining date to one cell with uniform results
 

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.

Combining date to one cell with uniform results
 

suppose A1 u have 3/08/1955, put B1 =DAY(A1)&MONTH(A1)&YEAR(A1)




On May 29, 11:37*pm, Gail wrote:
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.

Combining date to one cell with uniform results
 

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


"Gail" wrote:

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.

Combining date to one cell with uniform results
 

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

"Gail" wrote in message
...
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.