Custom Number Format

Rob #4

Board Regular
Joined
Jun 19, 2003
Messages
192
How do I create a custom number format that always returns 5 digits? Examples:

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

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,511
Office Version
2010
Platform
Windows
Is that a space between the #2 and following numbers? If so, your values are text and cannot be formatted.
 

Rob #4

Board Regular
Joined
Jun 19, 2003
Messages
192
No, its just how the post formatted it for some reason. It should just be 2, 22 and 222
 

Forum statistics

Threads
1,082,629
Messages
5,366,645
Members
400,908
Latest member
currong

Some videos you may like

This Week's Hot Topics

Top