» Problem: Date Formatting Cannot Be Changed in Excel 2007
CATEGORY - Excel Date and Time
VERSION - Microsoft Excel 2007
1. Select the column formatted as date.
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, select the Date option button in the Column data format section, and click Finish.
Book Store:
Recommended Books:
- Personal Finance for Dummies
- Microsoft Excel VBA Programming for the Absolute Beginner
- Marketing Planning for Services
- Financial Statement Analysis with S&P insert card
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
