Leading Zeros in number column?

1

Hi All,

I was wondering if there is any way to have a number column always have lets say 3 numbers. So the first row would be 001 and the 20th 020.

Thanks for helping!

2

Hi @Remco_de_Louw :blush: !

A Number column, I don’t so :thinking: (The supplementary “zeros” will be ignored)… But a Text Column in which you could use LeftPad() should work :blush: .

It depends on how important the format of that column is :blush: .

1 Like
3

Ah thank you! I will try it out.

4

No problem :blush: !

Just in case, here is a quick sample I should have shared earlier (:sweat_smile:) but forgot to do so (:innocent: )

Formula in LeftPad - 1

thisTable.Find(thisRow).LeftPad(3,0)

Formula in LeftPad - 2

LeftPad(thisRow.[A Number],3,0)
1 Like
5

Thanx it always helps to have a example!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.