Removing trailing minus signs while converting data to negative


show more Removing trailing minus signs while converting data to negative provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data show less
please wait ...

Removing trailing minus signs while converting data to negative

Trailing minus signs, although common in some accounting software, just don't work in Excel, and you need to get rid of them. And just as important of course is not only getting rid of them, but making sure that those values are turned into negatives. And there is a fast way to take care of this. Select the data, or in this case here let's select all of the data in Column T, and simply use a feature that's available on the Data tab in the Ribbon, Text to Columns, a great tool for splitting text into columns.

But here, we're going to take care of the data within the existing cells. We don't need an extra column to the right necessarily. First step in this wizard, simply choose Delimited. Move on to step two. Nothing really to do there. Go onto step three and click the Advanced tab. And the setting we're talking about might already be in place, but check it out anyway, trailing minus for negative numbers. Click OK, Finish, watch Column T, and you see what's happeni...

Removing trailing minus signs while converting data to negative
Video duration: 2m 3s 1h 28m Appropriate for all

Viewers:

Removing trailing minus signs while converting data to negative provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data

Subjects:
Business IT
Software:
Excel
Author:
please wait ...