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