I have a conditional statement that looks at the value in one cell, then
displays a message in another cell that addresses the result of the first
cell. The function I am using is as follows:

=IF(F30,"Increased by: "&F3&" C/Ft3",IF(F3=0,"No Change","Decreased by:
"&ABS(F3)&" C/Ft3"))

The result of this is the number in cell F3 which in F3 is formated as
scientific is displayed as "Increased by: .0001122355 C/Ft3".

I would like it to be displayed as "Increased by 1.12E-04 C/Ft3".

Is these a way to do this?

Thanks!