How to print numbers with dots, regardless of locale
posted twice by mistake...
--
Stefano Gatto
Have no fear of perfection - you''ll never reach it (Salvador Dali)
"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)
|