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!