View original (French)

Request for formula

AlbatrosImposant29 -  

Hello,

hello how to convert the digit in the cell into a number of zeros                             
example 5= 00000                            
 

example h7 =5     h9 display number of zeros (00000)

thanks .of course there is a formula?


3 answers

  1.  via55

    Hello

    Yes there is a formula, in H9 put:

    =REPT("0";H7)

    Best regards

    Via

    1. AlbatrosImposant29 Author

      thank you.

      it works.

      I will come back to you if I encounter a problem. because I do this for my son who is learning about (resistance code)

      1.  cousinhub29
        Hello l'Albatros

        Why multiply questions on different forums, and put all of this on your son's account?

        If you’re not comfortable with using a forum, keep at it on a single one.

        Multiplying sources can indeed bring a range of solutions, but is it really effective? (it seems not, since you keep posting...)

        Good luck