Formating Date from 8/5/13 to 20130805

[jomolee]

Hi

I was wondering how to format a date from 8/5/13 from one cell and 20130805 to another.
My purpose is to use the string of numbers as a item code/identifier.
Please advise, thanks!

PS Update: In a more advance question, which I'll post later on, I'm hoping to add a title after those string of number base on something else I have in another cell.

ie. 8/5/13 Item Name --> 20130805_ItemName

THanks!

[Sam Capricci]

You could try (if you're not looking for a format but a formula) this...
=YEAR(E76)&"0"&MONTH(E76)&"0"&DAY(E76)
where 8/5/13 is in cell e76, just substitute the cell it is located in.

[Jakobshavn]

With 8/5/13 in A1 and some text in B1, in another cell:

=YEAR(A1) & TEXT(MONTH(A1),"00") & TEXT(DAY(A1),"00") & "_" & B1

[Sam Capricci]

Would recommend using Jakobshavn's over mine since if the month or day becomes a double digit mine still adds a 0 to it so his looks better.

[jhren]

Date in A1, text-to-add in B1...

=TEXT(A1,"yyyymmdd")&"_"&B1

[FDibbins]

or just use custom formatting yyyymmdd

edit: sorry, didnt read the "to use the string of numbers as a item code/identifier" part, but you may still be able to use the 5-digit date number for what you want, without doing anything else

[jomolee]

Thank you guys! all solutions were amazing!