» Problem: Date Formatting Cannot Be Changed
CATEGORY - Excel Importing Text Files
VERSION - All Microsoft Excel Versions
To change the formatting from Text to Date, use 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, check Date option button in Column data format, and click Finish.


Book Store:
Recommended Books:
- Learn MS Excel 2002 VBA/XML Programming
- The Basics of Finance: Financial Tools for Non Financial Managers
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Word 2002: The Complete Reference
- Financial Risk Manager Handbook, Second Edition
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
No comments have been submitted.

