| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting number in VBA
I would like to have the result of the following line display with
only one decimal place. As written, it consistently displays to five decimal places. Obviously, because the output location is defined with a variable, I can't pre-format the cell it will be in. numQs and numWrong are Integers. Cells(I + 2, "B").Formula = "=" & (numQs - numWrong) / numQs & "*100" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number formatting | Excel Discussion (Misc queries) | |||
| number formatting | Excel Discussion (Misc queries) | |||
| Formatting a number | Excel Worksheet Functions | |||
| number formatting | Excel Worksheet Functions | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Threaded Mode
