M mike Feb 19, 2004 #1 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.
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.
F Frank Kabel Feb 19, 2004 #2 Hi try formating (Menu: 'Format - Cells') the cell with the custom format: MMDDYY
