How to print numbers invariably using dots as decimal symbol?
Try to override system settings in ToolsOptionsInternational by unchecking
"Use system separators" and entering dot as Decimal separator!
Regards,
Stefi
€˛Stefano Gatto€¯ ezt Ć*rta:
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)
|