Home

#FIELD! error when cop-pasting negative numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-826131%22%20slang%3D%22en-US%22%3E%23FIELD!%20error%20when%20cop-pasting%20negative%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826131%22%20slang%3D%22en-US%22%3E%3CP%3EI%20receive%26nbsp%3B%23FIELD!%20error%20whenever%20I%20copy%20paste%20a%20table%20with%20negative%20numbers%20that%20start%20with%20the%20minus%20(-)%26nbsp%3B%20sign.%20I%20tried%20different%20paste%20methods%20and%20to%20change%20the%20data%20type%20to%20number%2C%20general%20and%20text.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20looks%20like%20minus%20(-)%20sign%20is%20replaced%20with%20equal%20(%3D)%20sign%20during%20copy%20paste%20for%20some%20reason%2C%20while%20I'd%20like%20excel%20to%20keep%20the%20negative%20numbers.%20I%20searched%20and%20asked%20collegues%20with%20no%20avail.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826131%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826236%22%20slang%3D%22en-US%22%3ERe%3A%20%23FIELD!%20error%20when%20cop-pasting%20negative%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826236%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284154%22%20target%3D%22_blank%22%3E%40cansut%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FOpening-a-CSV-in-Excel%2Fm-p%2F718615%2Fhighlight%2Ftrue%23M33416%22%20target%3D%22_self%22%3ESee%20my%20comment%20over%20there.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
cansut
Visitor

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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies