Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Rounding

WernerDoubell
WernerDoubell ✭✭✭
edited 12/09/19 in Archived 2017 Posts

Hi, 

maybe a simple one: when I enter "0.00000872" into  a cell - smartsheet displays 0.00001?

How do I get it to display the actual value instead of the rounded value?

Thx

Tags:
· Share on FacebookShare on Twitter

Comments

  • Tony Coleman
    Tony Coleman ✭

    Would appear to be a system limitation of no more than 5 decimal places. .   Maybe as an alternative you can label that column to be "£ / % / time in hundreths / thousands of...."

     

    Regards

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    You could force it to be text by 

    =[column]row + ""

    but then would need to realize it was text before you did math on it and return it to a number using VALUE()

    Please write an enhancement request for this.

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories