| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting rid of trailing zeroes
How can I use the numberformat property as such:
1.000 becomes 100% 0.547 becomes 54.7% i currently have .numberformat = "0.#%", which gives 1.000 - 100.% (dangling decimal point) 0.547 - 54.7% (correct) ..numberformat = "0.0%" gives 1.000 - 100.0% (dangling zero) 0.547 - 54.7% (correct) wazooli |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Include trailing zeroes in calculation | Excel Discussion (Misc queries) | |||
| Can I set the default for "show zeroes" to not show the zeroes? | Setting up and Configuration of Excel | |||
| eliminating trailing zeroes imported into word document from excel file | Excel Discussion (Misc queries) | |||
| Sorry, leading zeroes again :-(( | Excel Discussion (Misc queries) | |||
| excel .txt to .cvs, lose trailing zeroes in numeric field | Excel Discussion (Misc queries) | |||
Threaded Mode
