Welcome to Forums Sign in | Join | Help | Forums
in Search


Forums » Product Forums » Crystal Reports » How do you turn Text into Number

How do you turn Text into Number

Last post 09-26-2003 11:13 AM by Genevieve Zevort. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 09-25-2003 4:53 PM

    • Genevieve Zevort
    • Top 25 Contributor
    • Posts 217
    • Organization: McGill University Health Center Foundation
    • Products:  The Financial Edge, The Raiser's Edge

    How do you turn Text into Number

    Reply Contact
    Over the years, ratings ($) have been entered using a table field (!). BB says that it is not possible to change this to straight text. However, Crystal will not subtotal what it consider be ... text. I can manage in Excel (by exporting in CSV or other tricks) but I am unsure how to solve this in Crystal - a formula probably. I am looking for suggestions. Thank you. Genevieve Zevort Information Systems MUHC Foundation

  • 09-25-2003 5:03 PM In reply to

    How do you turn Text into Number

    Reply Contact
    You can use the conversion function ToNumber. Crystal Reports help (F1) is very good for this sort of thing. A an example: ToNumber("123.45") Returns 123.45.

  • 09-26-2003 11:13 AM In reply to

    • Genevieve Zevort
    • Top 25 Contributor
    • Posts 217
    • Organization: McGill University Health Center Foundation
    • Products:  The Financial Edge, The Raiser's Edge

    How do you turn Text into Number

    Reply Contact
    Works perfectly. Thanks!
Page 1 of 1 (3 items)