Always show X number of digits in text box

[veronicahernand]

Hi,

I have these text boxes in my sheet:

As you can see, the size of the characters is different because of the number of digits that appear in each text box.

I would like to have the same number of digits in each text box, so I'd have the same text size in each text box.

I am trying to format the numbers but I can't find the way to do it...

Thanks

[JordyWegman · Accepted solution]

Hi,

You can try:

Num([YourField],'#,###.')

Jordy

Climber