Convert dates to 8 digit text
 

I have dates set as 01/01/2000 and I need to convert to 01012000.

Convert dates to 8 digit text
 

A custom format of

ddmmyyyy

Mike

"HelenONeill" wrote:

I have dates set as 01/01/2000 and I need to convert to 01012000.

Convert dates to 8 digit text
 

Format as ddmmyyyy (or as mmddyyyy, if you prefer).
--
David Biddulph

"HelenONeill" wrote in message
...
I have dates set as 01/01/2000 and I need to convert to 01012000.

Convert dates to 8 digit text
 

if you really need it as text
=text(A1,"ddmmyyyyy")
assuming it is days before months if not
=text(A1,"mmddyyyyy")

"HelenONeill" wrote:

I have dates set as 01/01/2000 and I need to convert to 01012000.

Convert dates to 8 digit text
 

To actually "convert" to text you will need to Copy the suggested
formatted cell(s) and do a Paste-Special, Values. Then replace the old with
the new.

"HelenONeill" wrote:

I have dates set as 01/01/2000 and I need to convert to 01012000.