View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Formula & text in one cell

Something like this:

=TEXT(your_calculation,"$0.00")&" per hour"

Hope this helps.

Pete

On Nov 16, 1:18 am, samb wrote:
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?