| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying specific numbers
I need to display only numbers divisable by 10 in a cell, if the calculation
is not divisable by 10 it still needs to display in multiples of 10. Example: The product of 100 x .102 equals 102, but the value displayed needs to be 110. whatever the product of the formula, the display must be multiples of 10. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
| Displaying -ve numbers | Excel Discussion (Misc queries) | |||
| Displaying all numbers as positive | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
Threaded Mode
