• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Numeric formatting in XL

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Numeric formatting in XL

    Is there a way I can format a cell in Excel so that the data shown will always contain the same number of digits?

    E.g

    Numbers in the range 0-9 will display as: 000x

    Numbers in the range 10-99 will display as: 00xx

    etc

    TIA

    #2
    Originally posted by Mustang View Post
    Is there a way I can format a cell in Excel so that the data shown will always contain the same number of digits?

    E.g

    Numbers in the range 0-9 will display as: 000x

    Numbers in the range 10-99 will display as: 00xx

    etc

    TIA
    IF statement with LEFT, RIGHT (etc)?

    Comment


      #3
      Originally posted by Menelaus View Post
      IF statement with LEFT, RIGHT (etc)?
      Can you expand on that? Are you referring to conditional formating?

      Comment


        #4
        Go to Format -> Cells
        On the Number tab, select Custom
        In the Type box, enter 0000

        Comment


          #5
          Originally posted by Mustang View Post
          Can you expand on that? Are you referring to conditional formating?
          Yup.

          Comment


            #6
            Select cells / rows / columns you wish to apply the formatting to then...

            from the menu choose Format - Cells - Custom (may depend on version of excel)

            Enter a custom format of 0000



            That should do it.

            Comment


              #7
              Beaten to it LOL

              Comment


                #8
                Originally posted by thunderlizard View Post
                Go to Format -> Cells
                On the Number tab, select Custom
                In the Type box, enter 0000
                Originally posted by lightng View Post
                Select cells / rows / columns you wish to apply the formatting to then...

                from the menu choose Format - Cells - Custom (may depend on version of excel) Enter a custom format of 0000

                That should do it.
                Bingo!! Many thanks for your help!!

                Comment

                Working...
                X