Add leading zeroes to number, number formatting

[YOO629]

Hi all,

I've assigned a number value to a variable called x. This number goes from 1-105 but I would like the number to be displayed such that...

1 = 001
5 = 005
10 = 010
50 = 050
100 = 100
101 = 101

I think if I do a length counter I can probably get this done by manually adding the 0, does anyone have a cleaner way of getting this done?

[protonLeah]

custom format the column with 000

[PCI]

Try
E5 = your value
Somewhere = REPT("0",3-LEN(E5)) & E5

[Aardigspook]

Hi,

I haven't tried this, but if you want to set it in code, I think this should work [/fingers crossed]

Please Login or Register  to view this content.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

[YOO629]

thanks everyone! all of the suggestions were very helpful.

[Aardigspook]

You're welcome and thanks for the rep.