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

Question

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

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.

On English OS, they are different.

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

1 answer

Your answer

Answer 1

Emi Zhang-MSFT 30,051 Microsoft External Staff

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:

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.

Shuai, Angela 1 Reputation point

2022-09-02T00:56:15.84+00:00

They are not the same.
Decimal symbol is "." on English OS and it is "," on Russian OS.
Emi Zhang-MSFT 30,051 Reputation points Microsoft External Staff

2022-09-07T02:33:46.613+00:00

You can try to change the Russian OS decimal symbol as the same as the English and check the result.

Share via

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

1 answer

Your answer