Aug 28 2019 01:08 AM
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.
Aug 28 2019 01:50 AM