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.

Mobile Numbers

Ben Willmott

Ben Willmott ✭✭

05/11/16 edited 12/09/19 in Archived 2016 Posts

Im sure this would have been asked a thousand times?

But how do I stop the zero from being deleted from the begining of a mobile number?

0 ·

Comments

JamesR ✭✭✭✭✭✭

05/12/16

Ben,
enter the number as text. Type an Apostrophe ( ' ) before the leading 0

James

0 · Share on Facebook Share on Twitter
Dave D ✭✭

05/12/16

or change the column type to Contact List

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Is it possible to have a multiple line entry using a form?
This could be far-fetched, but is there any way to set up a form to where you can fill it out like this screenshot below? Where it is more than 1 line entry without having to enter 100 different submissions? Currently people email me this excel every week and I have to copy and paste it into a different excel sheet.…
Create Folder under Sheets Tab
I have several folders under my Sheets tab that I created in the past. Today I'm trying to create a new folder there and cannot do it. I can create a folder in a workspace, but not under my Sheets tab. Right clicking on "Sheets" shows a create option but no folder option anywhere to be found. Right click in a blank area of…
Sum values based on corresponding value in second column
Hello, I am working on a project aiming to calculate the remaining product cost for a list of contracts. I have two columns with data which both have multiple values separated by delimiters and need to add the values in column 1 (quantity shipped) if they match with a specific value from column 2 (dosage). Example Data:…