Custom Format with the first three characters as numbers leading with zeros.

[Livin404]

Greetings,

I'm trying to tweak my custom format ever-so slightly. I'm going to have folders starting with 001 EXP 72 to 365 EXP 72. I can go to format and use a simple custom format

"000"

and that will gets me the double leading zeros 1-9 and the leading zero 10-99. However, because I have EXP 72 following in the cell which cancels out the code I just placed.

Any suggestions,

Thank you,

 

[Fluff]

If you just put the number in the cell you can use this custom format 000" EXP 72"

 

[Livin404]

If you just put the number in the cell you can use this custom format 000" EXP 72"

Thank you, it worked, I had trouble at first, then I used Flashed Filled. I initially tried placing the 000 in " ", followed by ???. Thank you again.

 

[Fluff]

Glad to help & thanks for the feedback.