J
jsv
How do I convert 02/11/09 to 021109?
Thanks
Thanks
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.
J
Jim Thomlinson
Two possibles...
Just add a custom format. Right click the date and select Format Cells ->
Number tab -> Custom and change the format to ddmmyy
Or use the formula
=text(a1, "ddmmyy")
where your date is in A1.
Just add a custom format. Right click the date and select Format Cells ->
Number tab -> Custom and change the format to ddmmyy
Or use the formula
=text(a1, "ddmmyy")
where your date is in A1.
M
Mike H
Perhaps
=TEXT(A1,"mmddyy")
Mike
=TEXT(A1,"mmddyy")
Mike
S
Sheeloo
=TEXT("02/11/09","mmddyyyy")
If the date is in A1 then use this in any other cell
=Text(a1,"mmddyyyy")
If the date is in A1 then use this in any other cell
=Text(a1,"mmddyyyy")
M
MartinW
Hi,
Take a look here at Chip Pearson's site
http://www.cpearson.com/excel/jdates.htm
I think that should do what you want.
HTH
Martin
Take a look here at Chip Pearson's site
http://www.cpearson.com/excel/jdates.htm
I think that should do what you want.
HTH
Martin
D
David Biddulph
No, Martin.
That page is about Julian dates, which wasn't what the OP asked for.
That page is about Julian dates, which wasn't what the OP asked for.