» Problem: Date Formatting Cannot Be Changed
CATEGORY - Excel Importing Text Files
VERSION - All Microsoft Excel Versions
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:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Word Version 2002 Inside Out
- Business Plans For Dummies®
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
No comments have been submitted.
