Skip to Content
avatar image
Former Member

format number to go 6 decimal places on the right

I am currently using: =Sum(ToNumber([Tons Emitted])) + FormatNumber([Tons Emitted];"######.######")

I also tried =Sum([Tons Emitted]) + FormatNumber([Tons Emitted];"######.######")

I am getting the results to where half of my numbers are right, the other half it repeats the number as: 12345.612345.6

and I get values with two decimal places like:0.62.617708

What can I do to take a sum of numbers and have them show the number going out at a minimum of 6 decimals to the right??

Thank you

Angela

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 13, 2016 at 08:54 PM

    Hi Angela,

    Please disregard my previous post.

    Question: Why are you using Sum() + Formatnumber()?

    Instead, can you just use =Formatnumber(Sum([Tons Emitted]);"#,##0.000000")

    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2016 at 08:10 PM

    Hi Angela,

    Try this:

    =Sum(Formatnumber(ToNumber([Tons Emitted]);"######.000000")


    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi angela,

      You want to do sum and apply formatting on this fied "ToNumber([Tons Emitted])"??

      then create a variable/formula as Sum(ToNumber([Tons Emitted]))

      Then if you right click the column displaying this value you will get Format number option.

      If you apply format number function and right click the column you will see only Format text option. Basically it will vary based on the data type of the column

  • avatar image
    Former Member
    Apr 14, 2016 at 04:44 AM

    Hi Angela,

    Formatnumber function converts the output to text and this is unnecessary load if you want this format only for display purpose. So for better performance don't use the formula instead right click the column displaying these values --> Format number -->Custom --> mention the format what you want i.e. #,##0.000000

    Add comment
    10|10000 characters needed characters exceeded