View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Formula & text in one cell

Better, format the cells you want this in as 'Custom' and use this:-
$00.00" per hour"
This way the cell is numeric as opposed to text and can be used in
calculations,
Regards,
Alan.
"Alan" wrote in message
...
=A1*A2&" per hour" and format as currency, ie
your formula&" per hour"
Regards,
Alan
"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?