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.
See my comment over there.