| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Currency formating | Excel Discussion (Misc queries) | |||
| Conditional Formating - Currency | Excel Discussion (Misc queries) | |||
| Currency formating problem | Excel Discussion (Misc queries) | |||
| Currency formating problem | Excel Discussion (Misc queries) | |||
| Formating currency in text box | Excel Programming | |||
Linear Mode
