Thread: USD to $ amount
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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