Number & Text in same cell

[EMoe]

Hello Excel Wizards!

Is there a way to display a number and some text (like 2 or 3 letters)
in the same cell, using *"format cells, custom"* function.

Example: Display 28 tons in a cell as 28 tns. The 28 will keep updating
to a different value every so many minutes, but the tns, need to remain
in the cell to reflect the updated value in tons. Sometimes I need to
use t/h for tons per hour.

Not sure if this is possible. I have, in the past, placed the unit in a
cell next to the number, but in many other cases this is just not good
for me.

Thanks,
EMoe

 

[Steel Monkey]

Hi EMoe

Right click on the cell go to custom type in General" tns"

should be all you need to do

let me know how it goes

 

[Gord Dibben]

Custom Format of #,##0 "tns"


Gord Dibben MS Excel MVP

 

[EMoe]

Thanks Steel, Gord, and Skatonni!!!

That did the trick. You guys are the best !

Regards,
EMoe