add text to end of formula output
 

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?

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?

add text to end of formula output
 

Thank you very much, that is exactly what I was looking for

"Peo Sjoblom" wrote:

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?