fill up 2 digit entries to 4 digit ( 22 to 0022)

[chvizda]

Hi all

I have a fiels which has entries like

1488

323

2

1499

..

How is it possible to fil up the 1 to 3 digit entries with 0 in front to get a 4 digit entry with  leading zeros ?

1488

0323

0002

1499

Many thanks in advance

Steffen

[neilgallen · Accepted solution]

You would want a formula tool with

Padleft([field],4,”0”)

[Thableaus · Accepted solution]

Hi @chvizda 

@neilgallen is right. I just would add up that you need to convert your numeric field to a String type before using the formula.

Cheers,