number format in crystal report

[Former Member]

The numbers in formula field in the crystal report is export to 97-2003 excel and stored as General number( like a,b,c) and can not be used by Excel functions,like vlookup. I have to converse them into numbers, like 1,2,3. Is there any way I can do conversion in crystal report? I have tried tonumber() in crystal. It did not work.

[Former Member]

Crystal report 2016 SP4. version 14.2.4.2410

Thanks for your response! This question puzzled for a long time.

[abhilash_kumar]

Hi Hui,

Which version of Crystal Reports (version, service pack and patch) do you use?

-Abhilash