add text to end of formula output

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

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


"mgdarkman" <mgdarkman@discussions.microsoft.com> wrote in message
news:884334AB-8B38-42AB-8D5A-166E6E4A12FE@microsoft.com...
>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?

[mgdarkman]

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" <mgdarkman@discussions.microsoft.com> wrote in message
> news:884334AB-8B38-42AB-8D5A-166E6E4A12FE@microsoft.com...
> >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?
>
>