» Problem: The Minus Sign Appears to the Right of the Number
CATEGORY - Excel Importing Text Files
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Accounting and Financial Fundamentals for Nonfinancial Executives
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Fish! A Remarkable Way to Boost Morale and Improve Results
- The 22 Immutable Laws of Branding
easiness
guest
Just use Format->Cells, Alignment tab use Text direction possible options
