Thread: How to print numbers invariably using dots as decimal symbol?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Phil Hibbs Phil Hibbs is offline
external usenet poster
  
Posts: 100
Default How to print numbers invariably using dots as decimal symbol?
Hm, might need some work... how about this...

Dim OldSysDefault As Boolean
Dim OldSeparator As String
OldSysSep = Application.UseSystemSeparators
OldSeparator = Application.DecimalSeparator
Application.UseSystemSeparators = False
Application.DecimalSeparator = "."
...
Application.DecimalSeparator = OldSeparator
Application.UseSystemSeparators = OldSysSep

Phil Hibbs.
Reply With QuoteReply With Quote