View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dksaluki dksaluki is offline
external usenet poster
 
Posts: 48
Default Custom Format ... (#,##0.0_"lbs"@

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