Dave:
Thanks; How could I forget 'ye ole' Find and replace...
Too Quickly resorted to a formula solution. I need to
say someting to our IS dept about how these $0.00 values
are getting converted to the 13 space characters. The leading
apostrophe is not there.
Tks again,,
Jim

"Dave O" wrote:

How about a Find and Replace? Click Edit Replace; enter thirteen
hard spaces in the FIND box and leave the REPLACE WITH box empty.

Sometimes these cells come across with a leading apostrophe- let us
know if yours does too.