Excel format priority

[nemmi69]

In an Excel shared spreadsheet which decimal format takes priority, the spreadsheet or the users format?
This is mainly about the thousands separator and the decimal separator.

Is there a way to force the shared documents format as the priority?

 

[rlv01]

The thousands separator and decimal separator are defined by the Windows Regional Settings, and Excel normally uses those settings. If I understand you correctly, then you want to override the settings defined by Windows and change Excel to use different settings, presumably to whatever your preferred definition is. The answer is that it can be done:

    With Application
        .UseSystemSeparators = False
        .DecimalSeparator = ","
        .ThousandsSeparator = "."
    End With

But it is s a very heavy-handed way to solve your problem, because changing the setting as per the above changes the users's Excel configuration, and will affect every other workbook they have open - and will stay that way until they or you change it back; so a larger question is should you do it? As a user, I would be very upset if a colleague tried to do that without asking permission since it affects everything else I do in Excel.