format the source cells that you are highlighting and the sum will reflect
that. At least that has been my experience.

--
Regards,
Tom Ogilvy


"Ian Elliott" wrote in message
...
Thanks for any help.
I have a worksheet with macro where I type in the numbers I see on the
status bar "Sum=xxxxxx". It would be easier for me to type in the numbers
if
the status bar "Sum=" used commas to separate thousands. Is there a way to
do
this?
Thanks again.