Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
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
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,
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
Excel Formula:
"000"
Any suggestions,
Thank you,