Forum Discussion
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 b...
Apply the custom number format 0,000000 (or set the number format to Number with 6 decimal places).
- 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.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.
