How can I change the date format 01/01/08 to 010108
T Tom Hutchins Oct 16, 2008 #2 Select the cell and give it a custom format of mmddyy. Select Format >> Cells Hope this helps, Hutch
R rebecca Oct 16, 2008 #3 Tom Hutchins said: Select the cell and give it a custom format of mmddyy. Select Format >> Cells Hope this helps, Hutch Click to expand... 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)
Tom Hutchins said: Select the cell and give it a custom format of mmddyy. Select Format >> Cells Hope this helps, Hutch Click to expand... 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 Rick Rothstein Oct 16, 2008 #5 Try =SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","") Click to expand... Why not just this instead... =TEXT(A1,"ddmmyy")
Try =SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","") Click to expand... Why not just this instead... =TEXT(A1,"ddmmyy")
R Roger Govier Oct 16, 2008 #6 Because I like to make things more complicated than they need be, Rick<bg>
R Rick Rothstein Oct 17, 2008 #7 LOL -- Rick (MVP - Excel) Roger Govier said: Because I like to make things more complicated than they need be, Rick<bg> Click to expand...
LOL -- Rick (MVP - Excel) Roger Govier said: Because I like to make things more complicated than they need be, Rick<bg> Click to expand...
