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.

Cell deletes the number 0

Gina Harris

Gina Harris ✭

10/13/15 edited 12/09/19 in Archived 2015 Posts

Trying to type in a number that starts 00070002654 but the first three 0's keep disappearing.

Any suggestions

0 ·

Comments

Terri Pavlovic ✭✭✭

10/14/15

Preface your number with a '

For example:
'00070002654

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Project Intake form in one workspace updated the Intake sheet in another workspace
Hope everyone is doing well. I would appreciate any insights you may have. I used the Project Management Template (PMO) to create an new workspace. Did this by saving this folder structure as NEW and called it MS Onboarding Lite. PMO structure: MS Onboarding Lite The first time I used the PMO to create a workspace was for…
Rolling-up information from sheet and reports. Unable to group information.
I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the…
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?