Skip to Content
avatar image
Former Member

number format in crystal report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 16, 2017 at 11:44 AM

    Hi Hui,

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2017 at 01:29 PM

    Crystal report 2016 SP4. version 14.2.4.2410

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

    Add comment
    10|10000 characters needed characters exceeded