I am finding this difficult to explain, but ultimately I am wanting a cells value to be 12 characters long including +/- a decimal point and following zeroes.
Examples are 1200 would become +1200.000000 -20 would become -20.00000000 99999999 would become +99999999.00
I have tried
LENGTH, and formatting rules with no joy. The formatting rules only changed what the number displayed as, not what the value of the cell was.
Can someone help me with this? Is it possible to do it only with formulae and no scripting?