How to print numbers with dots, regardless of locale

  • Thread starter Thread starter Stefano Gatto
  • Start date Start date
S

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)
 
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...
 
tried:

Application.DecimalSeparator = "."

then switch back to

Application.DecimalSeparator = ","

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

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

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

Phil Hibbs.
 
Back
Top