On Dec 5, 2:13*pm, Bigfoot17
wrote:
I have a cell (Buttons!B4) that has a date (12/5/08) in it formatted to show
as 5-Dec.

What I would like to do is have this date, or any date in this cell, as a
6-digit text string (120508) so I can use it in the file name when saving the
file. *Any suggestions appreciated.

Right click on the cell and choose format cells. Then choose Custom
as your format and for type, type in 'mmddyy'