View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Formula & text in one cell

Hi

FormatcellsNumberCustom $##.00 "per hour"
Enter your formula in the cell, the result will show $16.99 per hour, but
the cell value will be 16.99 which can be used in further calculations if
required
--
Regards
Roger Govier



"samb" wrote in message
...
I am trying to add a label to the numbers in one cell. I want the formula
to
calculate the numbers, but then I want it to say "per hour" after the
numbers
in the same cell. So, for example, the cell would read "$16.99 per hour"
How can I do this?