Forum Discussion

Danny-r's avatar
Danny-r
Copper Contributor
Nov 12, 2021

Custom Cell Formatting

Hi, 

 

I'm wanting to create a custom number format but struggling to do so.

 

Essentially, the number needs to be 0,000000. It may occasionally be 2,000300, or 1,002100, but basically needs to build it up to 6 digits after the comma. Is that possible?

excel

3 Replies

    • Danny-r's avatar
      Danny-r
      Copper Contributor
      Nov 12, 2021
      So with the custom number format of 0,000000, which I did get. I entered the identifier 1, 12881. The result should hopefully be that it extends it to 1, 0012881, but it changes it to 0,112,881, and when I go back to custom number format it has changed to 0,000,000

      With number and 6 decimal places, it can produce either 112681.000000 or 1.126810, which isn't what I'm looking to produce.

      For some context, the number before the comma is a categoric identifier, and the number afterwards is the identifier. This cannot be changed.
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Nov 12, 2021

        Danny-r 

        That wasn't clear to me from your original question.

        I'd place the category identifier in one column (say in A2 and down) and the other identifier in another column (e.g. in B2 and down). So you'd enter 1 in A2 and 1234 in B2.

        In C2, enter the formula =A2&","&TEXT(B2,"000000")

        If you use comma as decimal separator, it should be =A2&","&TEXT(B2;"000000")

        This can be filled down.

Resources