Forum Discussion
Excel number format, 0, thousand and negative
As long as the numbers are greater than -1000000000 and less then 1000000000, you can use the custom number format
[<=-1000000]-0 000,;[>=1000000]0 000,;0,
If you have numbers less than or equal to -1000000000 or greater than or equal to 1000000000, there is no single custom number format that will do what you want.
As long as the numbers are greater than -1000000000 and less then 1000000000, you can use the custom number format
[<=-1000000]-0 000,;[>=1000000]0 000,;0,
If you have numbers less than or equal to -1000000000 or greater than or equal to 1000000000, there is no single custom number format that will do what you want.
Just a quick question, when you said the limits are, the number needs to be within -1000000000 and 1000000000, do you mean the original numbers or the expected displayed number after formatting?