DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish.


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 07:03:03 -0700, util wrote:

I have just the opposite issue - I need:
08242007 converted to 08/24/07
Please help - I'm getting ############# error not due to column size..
Thanks



"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie