View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Format millions in thousands with comma

In place of
#,
Use
###,###,
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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.