Skip to Content
0

number format in crystal report

Dec 15, 2017 at 08:38 PM

53

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Dec 16, 2017 at 11:44 AM
0

Hi Hui,

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 18, 2017 at 01:29 PM
0

Crystal report 2016 SP4. version 14.2.4.2410

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

Share
10 |10000 characters needed characters left characters exceeded