Hi,

I have a cell that has a value of 1/1/2006, and the format displays it
as Jan '06.

I would like to paste the format of that cell into a new cell so that
the value of the new cell is Jan '06, not 1/1/2006.

Is this possible in Excel or VBA?

Excel 2003

thx,
Bodi