ExcelBanter - Excel percentages greater than 99%

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel percentages greater than 99% (https://www.excelbanter.com/excel-discussion-misc-queries/4247-excel-percentages-greater-than-99%25.html)

Dee

Excel percentages greater than 99%

How can I format an Excel cell so that a formula value of 100% is not
displayed as 0%?

IanRoy

Hi, Dee;
Can you explain? 0.99=99% 1=100%, 1.25=125% My copy of Excel has no problem
displaying these.
-IanRoy

"Dee" wrote:

How can I format an Excel cell so that a formula value of 100% is not
displayed as 0%?

All times are GMT +1. The time now is 01:02 PM.