Smartsheet Removing Zero

I have a course code 30657.201930 that I am pasting into a cell that is Text/Number. It drops the last zero, so it says 30657.20193, not 30657.201930.

I tried adjusting the decimal points, but I cannot get the zero to stay.

I'd like to keep the ability to paste the course code from another document, but I want to be sure the zero is not left off.

Any thoughts?

Find more posts tagged with

Sheets

Comments

Andrew Gross

You could try prepending the course number with a single quote.

Art Schneiderheinze

That's a good idea. How do I do that if I am pasting several cells from an Excel file (where the data originates)? It pastes that group of cells without the zero. I guess it could just be a part of my "clean up" of the data once it is in Smartsheet...?

Mike Wilday

I would add an additional column in excel and then use this formula to concatenate your value with a single quote...

=concatenate("'", Cell reference)

Replace Cell Reference with whichever row you're doing first, then drag down the cell's lower right-hand corner to convert all the numbers for you.

Then when you paste that number into smartsheet it will convert it to text and remove the single quote.

See screenshot below for more information.

Mike Wilday

Right-click the screenshot to view it larger in a new tab/window.

Suzanne Raphael

Can we just return to the central question here—WHY does Smartsheet remove the zero???? If I want a series of cells to mark progressive software releases, I NEED MY ZERO. eg. v1.8, v1.9, v2.0

How about not making me come up with some special formula or formatting workaround to just faithfully display what I've typed into a cell????

Bewildered,

Suzanne

JanelleQ

So this is something of a wonky but effective solution. Format the column to a different kind. ie. Instead of Text/Number, make it a date column. Or symbols. (Double click on column name to change)

It should still let you type in the box, and it won't remove your zeros. I hope this helps until there's an actual change in the program.

Mikeo

I love your wonky solution JanelleQ, it worked for me.

Sign in to join the conversation!

Quick Links

Trending discussions

How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…