Thanks. Could I bug you for something. No one seem to anwering me on Subject:
Gray out Sub Totals not being used. Could you take a look at it for me? Thanks

"Dave Peterson" wrote:

If the data is in a single column, you could select that column and use
data|text to columns (in xl2003 menus)

Fixed witdth, but don't draw any lines
and then choose date (ymd) as the field as the column format

And then format the range the way you like.

pgarcia wrote:

How can I fix this? I had used a formula years back but can't remmeber how it
goes. Thanks

=DATE(right(A1,2),mid(a1,5,2),left(A1,4))

but it does not work.

Thanks

--

Dave Peterson