How to print numbers with dots, regardless of locale

[Stefano Gatto]

Hello,

I need to print to a disk file, numbers that are stored in different cells
of a worksheet, by making use of the dot as decimal symbol. I thought of
loading them in variants first and printing from there a formatted string to
the file, using the FORMAT function.

However, format "0.00" will use the decimal symbol as defined in the locale
(Regional Settings), which is the opposite of what I need.

Does someone know if FORMAT can be instructed to invariably use a dot as
decimal symbol?

Thank you.

Stefano Gatto
Have no fear of perfection - you''ll never reach it (Salvador Dali)

 

[Stefano Gatto]

posted twice by mistake...

 

[Stefano Gatto]

Thank you Joel, but this will not work if the number is greater or equal to
100 (or -100).
However the idea of writing whatever comes and replacing it by a dot is not
a bad one, since we are from now on dealing with strings...

 

[Jarek Kujawa]

tried:

Application.DecimalSeparator = "."

then switch back to

Application.DecimalSeparator = ","

?

 

[Stefano Gatto]

You're right!

 

[Stefano Gatto]

Yes, I tried, but the FORMAT() function seems not to take care of that Excel
option.

....

 

[Phil Hibbs]

Yes, I tried, but the FORMAT() function seems not to take care of that Excel

option.

Indeed, as stated in the other thread on the same subject, the FORMAT
() function uses the Windows setting, not the Excel setting.

Phil Hibbs.