excel question (date format)

[badorties]

for dates, i have data that's in YYYYMMDD (20070523)

i need to calculate time, but excel won't recognize it as a date in any format or configuration ... i've tried several formulas, cheats, gimmicks and a few feeble searches

any ideas for how to get it to MM/DD/YY ...?

[J.Clints]

for dates, i have data that's in YYYYMMDD (20070523)

i need to calculate time, but excel won't recognize it as a date in any format or configuration ... i've tried several formulas, cheats, gimmicks and a few feeble searches

any ideas for how to get it to MM/DD/YY ...?

have you formated the Cell to read that way?

[angrymissy]

Download this free utility (saves me so much time @ work)

http://www.asap-utilities.com/

You can put the format of the date in there and it will covert easily for you

Once you download it, go to "Text" on the menu, then "Convert Dates" and here is how it works:

http://i9.photobucket.com/albums/a63/angrymissy/Image1.jpg

[celery]

if your yyyymmdd data is in cell A1, use this:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

[weezcase]

how bad do you guys hate your jobs?

[J.Clints]

how bad do you guys hate your jobs?

And then what happened?

[TheRealEddie]

how bad do you guys hate your jobs?

Yeah, excel sucks. Matlab rules!!!!

[badorties]

if your yyyymmdd data is in cell A1, use this:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

thanks, will give it a try once i get back to the office ..

Download this free utility (saves me so much time @ work)

http://www.asap-utilities.com/

You can put the format of the date in there and it will covert easily for you

Once you download it, go to "Text" on the menu, then "Convert Dates" and here is how it works:

http://i9.photobucket.com/albums/a63/angrymissy/Image1.jpg

if the above doesn't work, i'll try to sneak this onto my stubborn platform

how bad do you guys hate your jobs?

i love spreadsheets, taking thousands of lines of data and parsing them any which way you like is really cool ... it's just sometimes there's a few bumps -- the best part is that there's always someone who's been there and has some advice

thanks again

[badorties]

if your yyyymmdd data is in cell A1, use this:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

works like a charm, hope you have an amazing weekend ... thanks again