Thread: Need to have a dot used as decimal symbol, regardless of locale
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefano Gatto Stefano Gatto is offline
external usenet poster
  
Posts: 59
Default Need to have a dot used as decimal symbol, regardless of locale
Hello,

I would like to print to a disk file decimal numbers stored in numerical
cells, by using the dot as decimal symbol.
As per my tests, Format(8.26,"0.00") will print either 8.26 or 8,26
depending on the locale. I need 8.26 to be printed regardless of the locale.
Any suggestion?

Thanks,
Stefano Gatto
Have no fear of perfection - you''ll never reach it (Salvador Dali)
Reply With QuoteReply With Quote