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.

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

"Sloth" wrote:

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.

Another approach:

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


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=482354

Hi

Try formatting as 0.# "ib/ft"

Regards

Roger Govier


Sloth wrote:
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.

Typo - that should have been

0.# "lb/ft" of course

Regards
Roger

Roger Govier
Technology 4 U

Tel 01873 880266 Mob 07970 786191



Roger Govier wrote:

Hi

Try formatting as 0.# "ib/ft"

Regards

Roger Govier


Sloth wrote:

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.

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.


"Roger Govier" wrote:

Typo - that should have been

0.# "lb/ft" of course

Regards
Roger

Roger Govier
Technology 4 U

Tel 01873 880266 Mob 07970 786191



Roger Govier wrote:

Hi

Try formatting as 0.# "ib/ft"

Regards

Roger Govier


Sloth wrote:

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.

On Fri, 4 Nov 2005 14:19:08 -0800, "Sloth"
wrote:

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