Currency Formating
I would like to format currency as #,### not #,###.## . I also would like to
avoid using .NumberFormat = "$#,##0_);($#,##0)". The application is will be deployed internationally and I want to leverage the regional setttings as much as I can. Any thoughts? |
Currency Formating
One approach:
? application.International(xlCurrencyCode) $ Look at application.International to build your formatting string. -- Regards, Tom Ogilvy "Sanj" wrote in message ... I would like to format currency as #,### not #,###.## . I also would like to avoid using .NumberFormat = "$#,##0_);($#,##0)". The application is will be deployed internationally and I want to leverage the regional setttings as much as I can. Any thoughts? |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com