|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#3
01-15-2013, 09:04 AM
|
|||
|
|||
Problem solved thanks to JohnWilson!
Your second suggestion: ##%;##% works for percentages - thank you very much, JohnWilson!
I also played around and found the following to work with percentages as well: #%;#% and 0%;0%. It doesn't seem to make any difference which format I choose, in my example. The first one looks like the code for whole numbers, but I haven't tried it since my chart is set up for percentages. 
|
| Tags |
| number formatting |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 If formula result is negative then display text
|
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
|
Custom Bar Charts
|
SMartinez | PowerPoint | 1 | 05-18-2012 05:20 AM |
| Sum required without consider the negative amount | PRADEEPB270 | Excel | 2 | 08-22-2011 04:23 AM |
| Start slides from a negative number | powerpointbry | PowerPoint | 12 | 06-29-2011 12:14 AM |
|
How to add the plus sign (+) automatically for the numbers which are positive?
|
Jamal NUMAN | Excel | 2 | 05-01-2011 03:15 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode