ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how have status bar "Sum=xxxxxx" use commas="Sum=xxx,xxx"? (https://www.excelbanter.com/excel-programming/331366-how-have-status-bar-sum%3Dxxxxxx-use-commas%3D-sum%3Dxxx-xxx.html)

Ian Elliott

how have status bar "Sum=xxxxxx" use commas="Sum=xxx,xxx"?
 
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.


Tom Ogilvy

how have status bar "Sum=xxxxxx" use commas="Sum=xxx,xxx"?
 
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.





All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com