Skip to Content
0
Jun 05, 2018 at 07:12 PM

Leading Zero for a Zip Code

236 Views Last edit Jun 05, 2018 at 07:57 PM 3 rev

I am reading an excel file in Crystal reports.

I have formatted the zip code field in excel as zip and it shows leading zero in excel. However, I just noticed, that the field contents are only changed for display in excel. So when Cr reads it, it sees no leading zero.

Thus in CR, it does not show the leading zero.

I did format of the field and ticked 'Leading zero' but still it does not show the lz.

is there anything else I need to do?

TIA, Phil