BobBarker
06-16-2011, 10:00 AM
I have a cell with the Custom format being:
#.#x
I want 2.3 to turn into 2.3x
But when I enter 0.9
It turns into .9x
And also
2.0 becomes 2.x
How do I require those 0s?
is there some special way to require # even if it is 0?
I tried _#._#x
I tried $#.$#x
I tried _-#._-#x
Can't figure it out
[EDIT] SOLVED IT
#0.0#x
#.#x
I want 2.3 to turn into 2.3x
But when I enter 0.9
It turns into .9x
And also
2.0 becomes 2.x
How do I require those 0s?
is there some special way to require # even if it is 0?
I tried _#._#x
I tried $#.$#x
I tried _-#._-#x
Can't figure it out
[EDIT] SOLVED IT
#0.0#x