Fresh Excel Tips

In this example, somehow, we have a list of negative numbers that we need to make readable by Excel. The problem is, as shown in the image below, we have the negative sign on the right of the values. We need to change this so that the negative sign appears on the left.  We will be using both the LEFT and LEN functions to achieve this. This tip should work in Excel 97, 2000, 2003 and 2007.

1. In a worksheet, enter a series of numbers in cells A2:A10 that have a minus sign at the end.
2. Select cells B2:B10 and type the following formula: =-LEFT(A2,LEN(A2)-1).
3. Press CTRL+Enter.

You should now be set!

1. How to Check for Valid Numbers Using the T Function in Excel
2. How to Use the FIXED function to round and convert numbers
3. How to check for invalid values using the TYPE function in Excel
4. Convert negative values to positive using Excel
5. How to Use the SIGN function to check for the sign of a number