Transferring number formats across international locales

[John Cleese via OfficeKB.com]

I need to be able to store decimal numbers in excel cells that are as
recognisable in all international number formats, as they are in my own
international locale format.

You will be aware that some international number formats use ',' (commas) to
denote decimal places, whilst others use '.' (points). I have tried to write
a macro that will write a decimal number into a cell, and have tried to
define the number format by making use of the lines:

Range("$A$1"),numberFormat = "0.0000" OR Range("$A$1").Value = Format(number,
"0.0000")