#FIELD! error when cop-pasting negative numbers

Copper Contributor

I receive #FIELD! error whenever I copy paste a table with negative numbers that start with the minus (-)  sign. I tried different paste methods and to change the data type to number, general and text. 

 

It looks like minus (-) sign is replaced with equal (=) sign during copy paste for some reason, while I'd like excel to keep the negative numbers. I searched and asked collegues with no avail. 

1 Reply