Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
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
