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

Pete

On Nov 3, 4:52*pm, Jodie wrote:
Both options worked great.
Thanks!
Jodie



"Pete_UK" wrote:
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

On Nov 3, 4:16 pm, Jodie wrote:
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- Hide quoted text -

- Show quoted text -