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

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

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

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


Custom format of .0000"T"

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

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

"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

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

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

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

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


"Sheeloo" wrote:

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

"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

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

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

"Glenn" wrote:

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


Custom format of .0000"T"

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

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

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

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 -