Hi
Appreciate is someone could assist with Excel number formatting.
I hope to be able to format
12000 as 12
700 as 0.7
-12000 as -12 (in red)
-700 as -0.7 (in red)
I tried using several number formats
I hope to achieve results without need to use Conditional Formatting.
Thanks.
Regards
Victor
Appreciate is someone could assist with Excel number formatting.
I hope to be able to format
12000 as 12
700 as 0.7
-12000 as -12 (in red)
-700 as -0.7 (in red)
I tried using several number formats
- #,##0,_);[Red](#,##0,)
- [>=1000]#,##0,;[<1000]0.0,
I hope to achieve results without need to use Conditional Formatting.
Thanks.
Regards
Victor