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.