ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   remove percent symbol on percentage formatted cells in excel (https://www.excelbanter.com/excel-discussion-misc-queries/83765-remove-percent-symbol-percentage-formatted-cells-excel.html)

IncognitoPC

remove percent symbol on percentage formatted cells in excel
 
Hello,

I'm trying to get a cell to have a percent format but not display the
percent symbol "%".

How can I do that? if at all.



Dave O

remove percent symbol on percentage formatted cells in excel
 
It can surely be done, at the risk of confusing people who don't know
what they're looking at. In whatever percentage calculation you have,
multiply the result by 100, or at the end of the calculation add "*100"
( star one zero zero without the quotes).



All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com