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:


  • Travis
    Travis Employee


    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.