Text/Number column is editing my number

Christian Jensen

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?

Etienne Desbiens

You simply need to add " ' " before your number to keep the zeros.

 

Hope that helps,

 

Étienne

J. Craig Williams

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

Kennedy Stomps

Hi Craig-- I've added your vote for this to our enhancement request list! 

Christian Jensen

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.

J. Craig Williams

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