combine text and calculation (value of 0.000) in the same cell

[Jodie]

I am trying to have a calculation and text in the same cell. My calculation
is C12-B11, which currently gives a value of 0.000 ,but may change at some
point to something other than zero.
When I use =TEXT(C12-B11,".####""T""") I get .T in the cell.
When I use format cells, custom .####"T" I get .T in the cell.

What I want to see is .0000T
Does anybody know how to do this?

Thanks,
Jodie

 

[Glenn]

I am trying to have a calculation and text in the same cell. My calculation
is C12-B11, which currently gives a value of 0.000 ,but may change at some
point to something other than zero.
When I use =TEXT(C12-B11,".####""T""") I get .T in the cell.
When I use format cells, custom .####"T" I get .T in the cell.

What I want to see is .0000T
Does anybody know how to do this?

Thanks,
Jodie

Custom format of .0000"T"

 

[Sheeloo]

Use
=TEXT(C12-B11,".####") & "T"
or Format the cells as
..#### T

 

[Pete_UK]

Try it this way:

="The answer is "&TEXT(C12-B11,".0000T")

or you could try:

="The answer is "&TEXT(C12-B11,".0000")&"T"

Hope this helps.

Pete

 

[Sheeloo]

It should have been
..0000T or .0000 T

Use
=TEXT(C12-B11,".####") & "T"
or Format the cells as
.#### T

 

[Jodie]

The custom format of .0000"T" worked great. And if the value of C12-B11
changes to something other than zero, I get the real value.
Thanks!
Jodie

 

[Jodie]

Both options worked great.
Thanks!
Jodie

Try it this way:

="The answer is "&TEXT(C12-B11,".0000T")

or you could try:

="The answer is "&TEXT(C12-B11,".0000")&"T"

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Jodie - thanks for feeding back.

Pete