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.
Text/Number column is editing my number
I input the number 2800.06610 and Smartsheet edits my number to 2800.0661 which means it is eliminating the zero. This column does not have any conditional formating. What am I doing wrong?
Comments
-
You simply need to add " ' " before your number to keep the zeros.
ย
Hope that helps,
ย
รtienne
-
Christian,
ย
Etienne's answer converts the number to text - so any calculations that need the value will be incorrect.
ย
You could of course increase the number of digits displayed but thenย
2800.06 would show as 2800.06000 which may not be what you want either.
ย
I would vote for a "show all digits".
That feature is missing from all spreadsheet programs I have used.
ย
Craig
-
Hi Craig-- I've added your vote for this to our enhancement request list!ย
-
Microsoft Excel states that formatting a cell as text: โText format cells are treated as text even when a number is in the cell. The cell is displayed exactly as entered.โ Sounds more like a bug. But Iโll cast a vote to make a text/number field act like MS Excel.
-
Christian,
ย
I want to see the number as the system sees the number.
In the API doc, there is a cell.Valueand a cell.displayValue.
I want to the option to have the displayed value be the actual cell value.
I don't want it to be turned into text.
ย
If you decide to convert to text, you can use the VALUE() function in formulas to turn it back.
ย
Craig
