You would need extra cells with formulas for that, there is no way of
formatting dates to quarters
Besides what are your quarters, it depends on the financial year or are
talking strictly calendar like Jan-Mar = 1st quarter

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Linndek" wrote in message
...
For instance if I have a series of dates within a number of years, but I
want
to represent them as 1st Quarter 2005, 3rd Quarter 2006 etc