Displayed number format
 

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!

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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!
.

Jason,

Thanks for the help!

Kevin

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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!
.