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?