|
» Problem: Date Formatting Cannot Be Changed
CATEGORY: Excel Importing Text Files |
VERSIONS: 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. |
| Screenshot // Problem: Date Formatting Cannot Be Changed |
   |
|
RATING:
3.39
VIEWS: 19703 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
