A
Aaron
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.
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.