IDG Answers is a community of experts who are passionate about technology. Ask a question or answer one below.
I’ve ran into this before, actually. I think it is caused by the default settings in the Advanced Text Import Settings. Anyway, there is a quick way to resolve it:
A. Select the imported data that has the trailing minus signs. You can select it all, including positive values, you don’t have to just choose the ones with negative value.
B. Select Data>Data Tools>Text to Columns.
C. In the Text to Column box that pops up, just click Finish, and it should fix it.
I learned this from a book called 101 Excel Tips or something like that and still have it on a sticky note next to my desk. Hope this helps you out.