I pull a table from Access into a spreadsheet containing among other things, a MM/DD/YY date. I want to take that date as an MM/YY to chart data by month. By formatting the cell as "Date Mar-01" it displays fine, but still reads the data as MM/DD/YY...pasting special only pastes it as 33000 or whatever number the date configures to. I'm trying to think of an easy way to do it. Anyone got one? I tried making one cell =month(A1) and another =Year(A1) but can't get them together to read Jan-09.
And if anyone has any idea why my charts mysteriously don't appear on my screen anymore I'd be delighted to hear. They just up and disappeared out of nowhere. They display fine on other computers, so it's something with my Excel settings? I have Office 2007.