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

 

[Kurt]

There are acouple of ways. Obviously, you can use two side-by-side cells
with one as the label and format the borders so it looks llike a single
cell. Of course the entire column will be that way. Another way is to store
the numeric value in a cell somewhere other than the cell where you want to
display the information, maybe even in a hidden column. Then using the
"TEXT" and "CONCATENATE" functions, you can format the output. For example,
if the cell containing the numeric value for tons is "B1", then in the
display cell you would enter something like:

= CONCATENATE(TEXT(B1,"0.00")," Tns").

...kurt

 

[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

 

[skatonni via OfficeKB.com]

Try custom format
## "tns" or ## "t/h"

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

 

[EMoe]

Thanks Steel, Gord, and Skatonni!!!

That did the trick. You guys are the best !

Regards,
EMoe