| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Place Rounding
Hi,
I have a cell that looks at a cell on another sheet and simply displays the contents if the conditions are right using an IF statement. Problem is, it displays the number as fully expressed 8.989348643268967E-05 and I just want a plain and simple 0.00008. I have tried formatting the cell as a number and setting the DP and also leaving it as general, but it still does it. On the sheet it gets the number from, its displayed as 0.00008. What am I doing wrong? Cheers, Aaron. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding errors when a "5" is the third decimal place using formul | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| changing to two place decimal | Excel Worksheet Functions | |||
| Fixed decimal place | Setting up and Configuration of Excel | |||
Threaded Mode
