CATEGORY: Excel Importing Text Files VERSIONS: Microsoft Excel 2007

To move the minus sign from right to left: Use the following formula: =VALUE(IF(RIGHT(A1,1)="-",RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1)) Or 1. Select the column containing numbers. 2. Select Data -> Convert Text to Table (in Data Tools Group). 3. In Step 1, select the Fixed width option button and click Next. 4. In Step 2 click Next. 5. In Step 3 click Advanced, check the box in Trailing minus for negative numbers. 6. Click Ok and then click Finish.

Rate this tip 1 2 3 4 5   RATING: 5.00   VIEWS: 1154 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Essentials of Accounting and Post Test Booklet 8, Eighth Edition Business Analysis with Microsoft Excel (2nd Edition) Special Edition Using Microsoft Office XP Windows XP Annoyances The 22 Immutable Laws of Branding Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books