164.5 and 164,5 will be regarded as the same when copied from Excel in XML Speadsheet format on Russian OS

Shuai, Angela 1 Reputation point
2022-08-31T08:01:07.157+00:00

I have copied the following numbers from Excel to clipboard.
![236483-image.png]2

I see they are the same in XML Spreadsheet format on the Clipboard on Russian OS.
236454-image.png

On English OS, they are different.
236442-image.png

Is this a bug? How can we distinguish them in XML Spreadsheet format on Russian OS?

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,051 Reputation points Microsoft External Staff
    2022-09-01T06:41:03.463+00:00

    Hi @Shuai, Angela ,
    Go to Control Panel- Region- Format tab- select Additional settings...- Check if the Decimal symbol are the same settings under Number and Currency tab between Russian OS and English OS:

    236735-image.png

    236822-image.png

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.