The reason I could not format it is because apostrophe got added to the
beginning of each number.

Dave Peterson wrote:
Record a macro when you change the formatting for those fields/columns. Include
that at the bottom of your existing macro.

And I'd bet you had something (a space character) in that last row. Clean up
your data and try again.

I made it work except for 2 things.
One:
[quoted text clipped - 34 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1