Custom Number Format

[Rob #4]

How do I create a custom number format that always returns 5 digits? Examples:

#2 = 00002
#2 2 = 00022
#2 22 = 00222

 

[Rick Rothstein]

How do I create a custom number format that always returns 5 digits? Examples:

[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=2]#2 [/URL] = 00002
[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=2]#2 [/URL] 2 = 00022
[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=2]#2 [/URL] 22 = 00222

Is that a space between the #2 and following numbers? If so, your values are text and cannot be formatted.

 

[Rob #4]

No, its just how the post formatted it for some reason. It should just be 2, 22 and 222

 

[Rick Rothstein]

No, its just how the post formatted it for some reason. It should just be 2, 22 and 222

In that case, just use 5 zeros (00000) as your Custom Format.

 

[Rob #4]

Thank you!