Tip Printed from ExcelTip.com

---

Problem: The Minus Sign Appears to the Right of the Number


To move the minus sign from the right to the left:
Use the following function:

=VALUE(IF(RIGHT(A1,1)="-",RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1))

In Excel 2002 & Excel 2003, this problem is solved in the following manner:

1. In Step 3 of 3 of the Text Import Wizard, or in Step 3 of 3 of Text to Columns (select from Data), click Advanced.
2. In the Advanced Text Import Settings dialog box, select the Trailing minus for negative numbers checkbox.