Proceeding Zeros to an already existing column.

C. Ruiz · 01/11/23

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?

sharkasits · 01/11/23

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

sharkasits · 01/11/23

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

C. Ruiz · 01/11/23

Thanks again for your help! That worked.

Best Answer