View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Format millions in thousands with comma

_($* #,##0,_);_($* (#,##0,);_($* "-"??_);_(@_)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"todd" wrote in message
...
I currently have the number (in general format)
20307710.83
but I want it to be
$20,308

I am currently using this as my format
_($* #,_);_($* (#,);_($* "-"??_);_(@_)
but that only results in
$20308

How do I add the comma?
Thanks in advance.