P Paul Mar 30, 2004 #1 How can I change a date in one column that looks like this 20040330 to look like 3/30/04 or 033004?
J JE McGimpsey Mar 30, 2004 #2 One way: Data/Text to columns. Click Next, Next. Select YMD from the date dropdown. Click Finish. Format the date however you wish using Format/Cells/Number..
One way: Data/Text to columns. Click Next, Next. Select YMD from the date dropdown. Click Finish. Format the date however you wish using Format/Cells/Number..
F Frank Kabel Mar 30, 2004 #3 Hi try 'Data - Text in columns' and choose the appropiate Date format in the wizard
