» Problem: Values Not Formatting as Numbers
CATEGORY - Excel Importing Text Files
VERSION - All Microsoft Excel Versions
1. Enter the number 1 into a cell and copy it.
2. Select the column formatted as text, press Shift+F10 or right-click, and then select Paste Special from the shortcut menu.
3. Select the Multiply option button in the Paste Special dialog box, and then click OK.
Option 2: Change the column formatting from Text to General using the Text to Columns technique:
1. Select the column formatted as text.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select the Fixed width option button.
4. Skip Step 2 of 3.
5. In Step 3 of 3, select the General option button in the Column data format section, and then click Finish.
Book Store:
Recommended Books:
- Financial Peace: Revisited
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Monte Carlo Methods in Finance
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Yes, You Can Time the Market!
No comments have been submitted.
