Suppose I have cell value
0.465 and I want to display it in the spreadsheet in green as
+46.5 if it is positive and
-46.5 if it is negative. I have applied the following format
but MS Excel changes this format to
[Green]+#.000%;[Red]-#.000% and displays the value as
+046%. I have tried other formats without success. Any ideas?
- MS Office Professional 2010 (Excel v14.0.7128)
- Libre/OpenOffice is not an option.