Custom Format ... (#,##0.0

Custom Format ... (#,##0.0_"lbs"@

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sid - 21 May 2008 02:11 GMT

I am trying to append "lbs" to the value in the cell, but this does
not seem to work.

Any help is appreciated.

Reply to this Message

dksaluki - 21 May 2008 02:24 GMT

Using the "&" symbol in the cell will add on to the value.
For instance: let's say cell A1 is 2, and B1 is 4. In cell C1 you
could say =sum(A1:B1)&" lbs" and it would show "6 lbs" in cell C1.
Notice the space right after the 1st quote mark, that's so it will
show a space in cell C1.

hope this helps
dk

Reply to this Message

sid - 21 May 2008 02:31 GMT

> Using the "&" symbol in the cell will add on to the value.
> For instance: let's say cell A1 is 2, and B1 is 4. In cell C1 you
[quoted text clipped - 4 lines]
> hope this helps
> dk

Thanks for the reply, but the values are direct entries. I was trying
to create a custom format assigned to the cell or column so that any
value entered has 'lbs' appended.

Reply to this Message

dksaluki - 21 May 2008 02:34 GMT

...and actually, you should be able to set the format like you had
specifically asked (!) in the format cells options. This was the
number format I used: #,##0.00" lbs" and it showed 375.75 lbs in
the cell for example. so again, notice the space.

Reply to this Message

sid - 21 May 2008 03:13 GMT

> ...and actually, you should be able to set the format like you had
> specifically asked (!) in the format cells options. This was the
> number format I used: #,##0.00" lbs" and it showed 375.75 lbs in
> the cell for example. so again, notice the space.

Thanks for the help. If you read the help it does not seem that
simple.

Reply to this Message