Format it to the number of significant digits, e.g. CellsFormatCustom
value of 000000

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bev Greene" wrote in message
...
Is there anyway besides formatting the cell for text to keep the left side
0
in a cell from disappearing? Product name Excel 2003

Thanks