» 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:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- How to Read A Financial Report
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
