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
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives