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.
Preserve leading 0's:
Options
Clint H.
✭
Comments
-
Hi Clint! There isn’t a function that will automatically add an apostrophe when adding numbers that start with 0 but depending on what you are doing in this column, you might consider using a Contact List column rather than a Text/Number column. Contact list columns will not strip out 0’s if they are located at the front of a number. Just note, these numbers will be formatted as text (not a number), just like if you used an apostrophe in a Text/Number column.
This discussion has been closed.
