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"
|