USD to $ amount
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
|