| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to transform the symbol "½" to .5 for me. Possible?? | Excel Discussion (Misc queries) | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
| Color Formatted Cells not showing color | Excel Worksheet Functions | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Linear Mode
