# Proceeding Zeros to an already existing column.

Options
✭✭✭

Hi, I'd like to add Proceeding zeros to an already existing column

Currently there are over 2000 rows in the, with a varying number of digits from 1-4. I'd like them all to be a 4 digit number.

So if the column has an entered number of 1, I'd like the proceeding zeros to make it a 0001

or 501, but 0501.

Is this currently possible?

• ✭✭✭✭✭
Options

I don't think you can update the column, but you can create a calculated field to do it. Would that work?

I was just playing with this the other day and this is what I came up with.

=LEFT("0000", 4 - LEN([column]@row)) + [column]@row

• ✭✭✭✭✭
Options

I don't think you can update the column, but you can create a calculated field to do it. Would that work?

I was just playing with this the other day and this is what I came up with.

=LEFT("0000", 4 - LEN([column]@row)) + [column]@row

• ✭✭✭
Options

Thanks again for your help! That worked.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!