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

....


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


"Jarek Kujawa" wrote:

tried:

Application.DecimalSeparator = "."

then switch back to

Application.DecimalSeparator = ","

?


On 30 Paź, 11:28, Stefano Gatto
wrote:
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)

.