converting dates

[mike]

There must be a simple way to convert 1/15/04 to 011504
and 1/6/04 to 010604.

Any help would be greatly appreciated. Thanks.

 

[Frank Kabel]

Hi
try formating (Menu: 'Format - Cells') the cell with the custom format:
MMDDYY

 

[Grey Newt]

Did you want a cell format or a VBA solution ?