Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    10

    Unanswered: ToNumber Decimal

    I have a formula that presents a number field with a decimal point and 2 following zero's to the right. How do I remove those so it is just a number?

    ToNumber ({PHPACCT.AAMMM})

    Looks like 4.00
    I want it to look like just 4

  2. #2
    Join Date
    Mar 2006
    Posts
    12
    in design mode, if you right click on the field and goto format field, then goto the tab number click customize. This will bring up some options. On the left side it will say Decimals: click the drop down and select 1, right now you probably have it as 1.00

    this should work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •