Custom Number Format

S

Sloth

I want a format that will show "35.4" as "35.4 lb/ft" and "35" as "35 lb/ft".
The trick being the decimal is not shown for the second number.

I currently use two different versions depending on the number, but I would
like this to be automaticly done in the format.
 
C

Carole O

Assuming 35.4 is in A1, in another cell, enter =A1&" lb/ft". Drag that down
the column to capture the 35 and change it to 35 lb/ft.

Carole O
 
S

Sloth

I should have shown the two formats I use.
0.0 "lb ft"
and
0 "lb ft"
If I use yours for 35 it will show as 35. lb/ft which is why I need to
change the format for number without any decimal digits.

MrShorty's method works. I didn't realise you could use General with other
stuff in the custom format.

Unfortunately Carole's method is not applicable because I want the cell to
still be a number. I just wanted an aesthetic change.

Thanks everyone for your input.
 
R

Ron Rosenfeld

I want a format that will show "35.4" as "35.4 lb/ft" and "35" as "35 lb/ft".
The trick being the decimal is not shown for the second number.

I currently use two different versions depending on the number, but I would
like this to be automaticly done in the format.
Click to expand...


Format/Cells/Number/Custom Type: General" lb/ft"

However, if the 35.4 is really a calculated number with more precision, you
will have to round it to 1 decimal place within your formula in order to assure
that only one decimal will be displayed.


--ron
 
Top