add text to end of formula output

M

mgdarkman

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?
 
P

Peo Sjoblom

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)
 
Top