Performing copy and paste from Excel results in wrong display of data

[kazuya.okamoto]

https://jsfiddle.net/cs4rhkxn/7/

This is what you see when you open and run my jsfiddle:

For easier explanation, try to create an Excel Sheet containing two cells with values (B3 = 1000, B4=1,000):

When I copy the B3 cell (value: 1000), then paste it to the C1 cell in JSFiddle:

Copy and Paste operation ends successfully.

However, when I try to copy the B4 cell (value: 1,000) in Excel, then paste it to the C1 cell in JSFiddle,

The value is getting to one (1).

Why is this happening?

I try to study the below Q&A, but still couldn’t understand how to fix this issue.

Excel copy paste from currency or accounting format

Hi there, Any thoughts on how to allow copy/paste from the currency or accounting format in excel? When I paste its throwing a validation error on numeric columns. Example below: [image] Copy and paste any currency into format info the jsfiddle below and you’ll see the red highlight http://jsfiddle.net/e3rq1sga/ [image]

[aleksandra_budnik]

Hey @kazuya.okamoto

this topic is pretty similiar to what I have already shared today. In this case you have a non-decimal value 1 and a decimal value 1.5 that is being formatted to 1.500