Percentage format cell. how to changedisplaying 1,0. to 1,0% (take 2)

[JOAO_PEREIRA]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Even if the original problem in the actual spreadsheet was solved with recent updates of Excel 2008, I found a similar problem when formating a pie graphic with Labels and Percentages fo each slice!
Instead of "1%" Excel writes "1."
I'm using localization Portugal in MAC OS and Office 2008 - 12.1.3
Any ideas how to solve this? It's really ruining my graphics.....

JP

 

[Skinman]

Try Format cells, custom format, Enter this #.00%

 

[JOAO_PEREIRA]

Hi skinman!
After formating the pie graphic labels with custom format #.00% , I get ".1%" rather than ".1".This is clearly an improvement. Thank you!

There is still that point (".") that I would love to kill.... any more ideas?

 

[Skinman]

Try #%

Hi skinman!
After formating the pie graphic labels with custom format #.00% , I get
".1%" rather than ".1".This is clearly an improvement. Thank you!

There is still that point (".") that I would love to kill.... any more
ideas?

 

[Skinman]

0.5 is 50.00% so 0.5 would format as 50.00%, .1 would format as 10.00% if
you are
getting after formatting .1% your cell value would have to be .001 You may
have to * your
cell values by 10 via copy 10, then paste special, values, multiply
If you don't want any decimal places after the 1 Format as #%

 

[JOAO_PEREIRA]

I have been working with excel formating options for more than 10 years, and I do understand that 0.5 is 50.00%. This is not a case of misinterpreting the excel formating options.
I have 0.04 in the cell and excel is writing ".4%" in the graphic pie.

I do believe this is the same bug excel2008 had in the spreadsheet view that was corrected recently but maybe is still present in the graphics app.
This bug could only be found when using Portuguese location in the system preferences.
Can you check this out?

 

[Pat McMillan]

Apologies for the slow reply on this, but thanks to this discussion we have
verified the problem Joao is reporting here with chart labels and we're now
investigating it.

Thanks,

Pat