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
