|
» Problem: The Minus Sign Appears to the Right of the Number
CATEGORY: Excel Importing Text Files |
VERSIONS: All Microsoft Excel Versions |
|
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. |
| Screenshot // Problem: The Minus Sign Appears to the Right of the Number |
   |
|
RATING:
3.42
VIEWS: 28203 |
||||
easiness
guest wrote on December 31, 1969 19:00 EST
Just use Format->Cells, Alignment tab use Text direction possible options
Sponsors:
 |
Book Store:
Recommended Books:
- Special Edition Using Microsoft Word 2002
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Accounting for Dummies
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
