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