Custom Number Format

[Guest]

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.

 

[Guest]

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

 

[Roger Govier]

Hi

Try formatting as 0.# "ib/ft"

Regards

Roger Govier

 

[Roger Govier]

Typo - that should have been

0.# "lb/ft" of course

Regards
Roger

Roger Govier
Technology 4 U
(e-mail address removed)
Tel 01873 880266 Mob 07970 786191

 

[MrShorty]

Another approach:

Format->Cells->Number->Custom->Type general "lb/ft"

 

[Guest]

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.

 

[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.

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