Leading '0' removed from field
I am linking a Crysta Report to an Excel spreadsheet and displaying the information. I am trying to display a field on the page that looks like 0810911071309. In the spreadsheet the format of this is "Custom" and 0000000000000. However, when I try and display this in my report the leading 0 from 0810911071309 is taken off.
Can anyone help me?
Thanks in advance
Ian Waterman replied
When crystal connects to Excel it ignores any excel formating and derives its data type from the first field it finds.
Thus crystal will treat your data as a number.
To restore your formatting use a formula
totext(yourexcelfield, "0000000000000", 0, "")
Replace field on design view with the above formula.