Zip code leading zero we want

[philky001]

HI I am downloading data from a report a cloud based system, to Excel. Looking at the zip code in the report it has a leading zero.
But when in this excel it loses the leading zero. So I made format and zip. It shows the leading zero but not really there
if you look at the top the content is without leading zero.

I would like to know the technique to re-establish this leading zero in full sense. Reason is because we are then reading this excel further on in a crystal reports.

 

[Nine Zero]

make a helper column perhaps if the zipcodes are in column A .... in column B do =TEXT(A1,"00000") and go down

 

[philky001]

Thank you that is huge helper!