Formatting within a formula

[WLMPilot]

I have done this before, but cannot remember how.

I am converting lbs to kg and using CONCATENATE to at the kg on the end of
the formula

Example: A1 = 220 lbs B1: =CONCATENATE(A1/2.2 &"kg)

I need to reduce the answer in B1 to two decimal places. I believe I can do
this within the formula, but not sure.

Thanks for you help.

Les

 

[Mike H]

Try

=CONCATENATE(TEXT(A1/2.2,"00.00"))&"Kg"

Mike

 

[Mike H]

A better solution would be to use a custom format of

00.00"Kg"

in B1. that way the underlying value isn't changed and you can still do math
on it.

Mike

 

[WLMPilot]

This kept returning a value of 00.00kg. However, your other option worked.
I could not figure out how to set the custom format up.

Thanks,
Les

 

[FSt1]

hi
another way...
=CONCATENATE(ROUND(A1/2.2,2) &" kg)

regards
FSt1

 

[Paulo]

I might be able to help you out, I say might because my excel is translated
and i might not spell right the items.

Format>cell>(from the menu select custom).

now, you have to figure out the way you need the data to be displayed, after
that. there is a type box that alows you to change. and on top of it there is
the sample.

in the end of whatever way you pick. there comes your customisation. the Kg
will not be part of the data from the cel. and you add it by typing in the
type box
" #.##0,00 \k\g "