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. |
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