How to format number with mixed number and text?

[nomail1983]

I put the following formula into a cell:
=6.65+0.15&" lb". It did what I intended, namely:
add the numbers and display the result with the
tag, i.e. "6.8 lb".

However, the Number format seems to have no effect
on the displayed result. For example, if Decimal
Places is 2, the above result is still "6.8 lb",
not "6.80 lb". I get more decimal places only if
they are "needed". For example, =6.65+0.1511&" lb"
displays 4 decimal places, even if the Number
format is 2 decimal places.

How can I control the format of the numeric part
of such "mixed" cell contents? Or is the lack of
control simply the cost of mixing content?

 

[RagDyeR]

Number formats work *only* for numbers!

Your " lb" converted your "number" to Text, no matter what the cell format
says.

So, try a *custom* format of:

#.00" lb"
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I put the following formula into a cell:
=6.65+0.15&" lb". It did what I intended, namely:
add the numbers and display the result with the
tag, i.e. "6.8 lb".

However, the Number format seems to have no effect
on the displayed result. For example, if Decimal
Places is 2, the above result is still "6.8 lb",
not "6.80 lb". I get more decimal places only if
they are "needed". For example, =6.65+0.1511&" lb"
displays 4 decimal places, even if the Number
format is 2 decimal places.

How can I control the format of the numeric part
of such "mixed" cell contents? Or is the lack of
control simply the cost of mixing content?