Hello all,
I need to add USD to a dollar amount. Could someone tell me what I would
need to add. I thought this would work but it gave me an error.
=text("USD")&sum(A1:A50)

Thanks

Right click|Format Cells|Currency.

OR

Use formula =DOLLAR(A1)

If this post helps click Yes
---------------
Jacob Skaria


"pgarcia" wrote:

Hello all,
I need to add USD to a dollar amount. Could someone tell me what I would
need to add. I thought this would work but it gave me an error.
=text("USD")&sum(A1:A50)

Thanks

hi
try ="USD " & DOLLAR(A1:A50)

regards
FSt1

"pgarcia" wrote:

Hello all,
I need to add USD to a dollar amount. Could someone tell me what I would
need to add. I thought this would work but it gave me an error.
=text("USD")&sum(A1:A50)

Thanks

Try this:

=TEXT(SUM(A1:A50),"\U\S\D #.00")

OR

=TEXT(SUM(A1:A50),"\U\S\D $#.00")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pgarcia" wrote in message
...
Hello all,
I need to add USD to a dollar amount. Could someone tell me what I would
need to add. I thought this would work but it gave me an error.
=text("USD")&sum(A1:A50)

Thanks