R
rebecca
How can I change the date format 01/01/08 to 010108
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.
T
Tom Hutchins
Select the cell and give it a custom format of mmddyy. Select Format >> Cells
Hope this helps,
Hutch
Hope this helps,
Hutch
R
rebecca
Tom Hutchins said:Select the cell and give it a custom format of mmddyy. Select Format >> Cells
Hope this helps,
Hutch
I ALSO NEED TO CHANGE THE FORMAT INTO A TEXT CELL. WHEN I TRY TO DO THIS IT
GIVES ME A NUMBER THAT EXCEL RECOGINZES AS A SUM NUMBER (I THINK)
R
Roger Govier
Hi Rebecca
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")
R
Rick Rothstein
Try
Why not just this instead...
=TEXT(A1,"ddmmyy")
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")
Why not just this instead...
=TEXT(A1,"ddmmyy")
R
Roger Govier
Because I like to make things more complicated than they need be, Rick<bg>
R
Rick Rothstein
LOL
--
Rick (MVP - Excel)
--
Rick (MVP - Excel)
Roger Govier said:Because I like to make things more complicated than they need be, Rick<bg>