First, don't hijack threads. If you have a new problem post it in a new
thread. You'll get a much better response.

Second, if you need it converted to a date, then just convert it. Try:

=date(right(a1,4),left(a1,2),mid(a1,3,2))

Regards,
Fred.

"util" wrote in message
...
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