BeyondMethod
New Member
- Joined
- Feb 22, 2004
- Messages
- 4
Hello all,
I need help trying to figure out some formula for Excel that can rearrange a series of numbers into a date. I have a spreadsheet in which the dates are entered as yearmonthday (YYMMDD), but for the year it doesn't include the zero.
For example:
12/03/99 comes out as 991203
12/03/00 comes out as 1203
12/03/01 comes out as 11203
Does anyone know of a formula I could use in Excel (or some other way in Excel) so that I can rearrange the numbers to make them actual dates in MM/DD/YY format? I'm kind of new at this, any help would be appreciated.
Thanks!
I need help trying to figure out some formula for Excel that can rearrange a series of numbers into a date. I have a spreadsheet in which the dates are entered as yearmonthday (YYMMDD), but for the year it doesn't include the zero.
For example:
12/03/99 comes out as 991203
12/03/00 comes out as 1203
12/03/01 comes out as 11203
Does anyone know of a formula I could use in Excel (or some other way in Excel) so that I can rearrange the numbers to make them actual dates in MM/DD/YY format? I'm kind of new at this, any help would be appreciated.
Thanks!