H
HelenONeill
I have dates set as 01/01/2000 and I need to convert to 01012000.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
A custom format of
ddmmyyyy
Mike
ddmmyyyy
Mike
D
David Biddulph
Format as ddmmyyyy (or as mmddyyyy, if you prefer).
B
bj
if you really need it as text
=text(A1,"ddmmyyyyy")
assuming it is days before months if not
=text(A1,"mmddyyyyy")
=text(A1,"ddmmyyyyy")
assuming it is days before months if not
=text(A1,"mmddyyyyy")
J
Jim May
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.
formatted cell(s) and do a Paste-Special, Values. Then replace the old with
the new.