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


--
Regards
Frank Kabel
Frankfurt, Germany

mike wrote:
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.