Forum Discussion

FreLu's avatar
FreLu
Copper Contributor
Sep 08, 2020

Excel number formatting

How to set number formatting in Excel for a three character number format where input "1" should read "001", input "10" should read "010" and so on?

 

1 Reply

  • FreLu's avatar
    FreLu
    Copper Contributor

    fixed it myself. Simply formatting by "000". Sorry for any inconvenience!

    FreLu 

Resources