| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If 100.0% display 100%
This became clear to me after reading more of the interchanges. It cannot be
done with a number format, so I decided to let anyone who wanted to write formulas or VBA get the glory. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "jmj713" wrote in message ... Perhaps I wasn't clear, I'm sorry. I wanted any whole number percentage (1.0%, 27.0%, 78.0%, 100.0%) to drop the .0 decimal. In your initial post, you said 100% is a whole number, which it is (100%=1), whereas 1% is a small fraction (=0.01 or 1/100). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
| how to display numbers in thousands i.e display 10,000 as 10 | Excel Worksheet Functions | |||
| Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel | |||
Hybrid Mode
