| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Displaying decimal places
Is there a way for me to have the data in a cell determine how many
decimal places should be displayed? For example, if the formula in the cell results in a number that is greater than (or equal to) 10, then I'd like to have zero (0) decimal places actually displayed. However, if the formula in the cell results in a number that is less than 10, I'd like to have zero (0) decimal places displayed. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| If then statement displaying 2 or 3 decimal places | Excel Worksheet Functions | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| Max decimal places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Threaded Mode
