.xls data field is NULL in crystal

[huytonscouser]

I have an input .xls file, that has a column (defined as custom, #######################)

the content of column looks like :-
5006016139a00f59
5006016139a020e7
5006016939a00f59
5006016939a020e7
50001442320014a0
50060482ccb4c2c7
50001442320014a8
50060482ccb4c2d8
5000144232001370


However, when i try and display this field in crystal, i never see the value "5000144232001370" i.e. all numeric.

As a test i defined a formuala :-

if isnull({Sheet1_.WWN}) then "null"
else
if isnumeric({Sheet1_.WWN}) then "numeric"
else "contains text"

the data displays as:-

5006016139a00f59 contains text
5006016139a020e7 contains text
5006016939a00f59 contains text
5006016939a020e7 contains text
50001442320014a0 contains text
50060482ccb4c2c7 contains text
50001442320014a8 contains text
50060482ccb4c2d8 contains text
null

How do i display the "5000144232001370" value

if i try and change the column (format cells) in excel to general i get 5.00014E+15

so is it the input .xls column data that is bad, or is there a workaround in crystal to display this column correctly.

 

[lbass]

Please see thread767-1652932.

-LB

 

[huytonscouser]

Excellent thank you, i changed the column to text using the "text to columns" wizard, and now crystal behaves correctly.