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
    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)

      0
      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
        0