View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default add text to end of formula output

You can use a custom format

0.00 "hours"

that way you can still do calculations with the cell

or

=SUM(A1:A3)&" hours"

which would be text

--
Regards,

Peo Sjoblom

(No private emails please)


"mgdarkman" wrote in message
...
I have a basic formula that I want to display a character after the
calculation.
example: A1+A2+A3=25.00
I would like to see: A1+A2+A3=25.00hrs

Is this possible?