NumberFormat vs. NumberFormatLocal

[roybrew]

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

 

[Tom Ogilvy]

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/Ch22/ProgRefCh22.htm
International Issues

 

[roybrew]

Well, we had a customer who was trying to set NumberFormat on a range
of cells with an English setting running on a German version of Excel.
This was throwing an error. They were then using this "error" to go
and set it with German settings. Now relying on an error to occur is
kind of a hack. The odd thing was a) that an error occurred at all;
and b) it didn't happen consistenly;

Changing the property set to NumberFormatLocal seemed to cause the
desired behavior (as flawed as it was) to occur.

Roy