NumberFormat using US English conventions should work.

Stephen Bullen has posted a chapter from his book for review on his site.
This chapter address International issues and give you more details and
recommendations:

http://www.oaltd.co.uk/ExcelProgRef/...rogRefCh22.htm
International Issues

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
Is it better to set the NumberFormat for a cell or range by using the
NumberFormat property or NumberFormatLocal? Should you be able to set
the number format in VBA code in english and have Excel do the
translastion for you ? Or should you just set the appropriate number
format with NumberFormatLocal?

Thanks in advance.
Roy