Using VBA to detect which decimal sign the computer is using

by

Regarding the answer above, it is important to know that Application.DecimalSeparator and Application.International(xlDecimalSeparator) do not behave the same way:

  • Application.DecimalSeparator will ALWAYS output the decimal separator chosen in Excel options even when Excel is told to use System Separators (from Windows regional settings)
  • Application.International(xlDecimalSeparator) will output whatever is the actual decimal separator used by Excel whether it comes from Windows settings (when Application.UseSystemSeparators = True) or from Excel options (when Application.UseSystemSeparators = False)

I therefore strongly recommend to always use Application.International(xlDecimalSeparator).

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. Excel Number Separation [closed]
  3. excel vba compare & copy worksheets from 2 excel files
  4. VBA Stuck after certain loop
  5. How do I use FileSystemObject in VBA?
  6. Is the . in .Range necessary when defined by .Cells?
  7. How to return a result from a VBA function
  8. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  9. Properly Handling Errors in VBA (Excel)
  10. Password hash function for Excel VBA
  11. Aggregate, Collate and Transpose rows into columns
  12. VBA Excel sort range by specific column
  13. Select method of Range class failed via VBA
  14. Excel VBA: getting row of clicked button [duplicate]
  15. VBA Many buttons point to the same _Click sub
  16. Excel VBA Filter Change event handler
  17. How to copy only values in excel vba from a range?
  18. How to suppress Update Links warning?
  19. How do we use restful APIs from Excel macros (vba)?
  20. Cannot VBA write data to cells in Excel 2007/2010 within a function
  21. Handle “No cells were found” error when filtered range is empty
  22. Excel: the Incredible Shrinking and Expanding Controls [closed]
  23. How to send email to multiple recipients with addresses stored in Excel?
  24. VBA: How to combine two ranges on different sheets into one, to loop through
  25. Excel VBA – select multiple columns not in sequential order
  26. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  27. Application.WorksheetFunction.Match method
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Delete all data rows from an Excel table (apart from the first)
  30. Excel telling me my blank cells aren’t blank

Leave a Comment