uberathlete
Board Regular
- Joined
- Jul 11, 2007
- Messages
- 117
Hi everyone. I've got this sheet of data in this form:
I would basically like to format the Date and Hour columns. The Dates are of the form YYYYMMDD and the Hours is of the form HHMMSS . How would I format the cells into a regular format (ie. MM/DD/YYYY) and also the hour (ie. h:mm:ss)? Any suggestions would be much appreciated. Thanks!
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Symbol | Date | Hour | Price | Volume | ||
2 | BAXF0 | 20000105 | 150018 | 94.79 | 50 | ||
3 | BAXF0 | 20000113 | 140948 | 94.78 | 20 | ||
4 | BAXF0 | 20000113 | 144030 | 94.79 | 25 | ||
5 | BAXF0 | 20000113 | 144054 | 94.79 | 25 | ||
6 | BAXF0 | 20000114 | 102048 | 94.78 | 50 | ||
7 | BAXF0 | 20000114 | 104400 | 94.79 | 150 | ||
8 | BAXF0 | 20000114 | 112612 | 94.78 | 100 | ||
9 | BAXF0 | 20000117 | 94936 | 94.78 | 25 | ||
Sheet1 |
I would basically like to format the Date and Hour columns. The Dates are of the form YYYYMMDD and the Hours is of the form HHMMSS . How would I format the cells into a regular format (ie. MM/DD/YYYY) and also the hour (ie. h:mm:ss)? Any suggestions would be much appreciated. Thanks!