Assuming your numbers are in column A,
in B1 put this and copy down.........

="000"&A1

then Copy PasteSpecial Values on column B to delete the formulas and
delete column A if desired


Vaya con Dios,
Chuck, CABGx3


"Jennifer" wrote in message
...
Hi,

I have a cell with 5 digits stored as text. I need to add 3 zeros to the
cell so my total digits in the cell = 7. How can I add the zeros to the
beginning of the cell?
ie. current digits = 4204, desired outcome = 0004204. The cell must
remain
in text format.

Thanks,
--
Jennifer