Thanks all for the help. I am inheriting this workbook and
unfortunately do not have the time to redesign it as I would like.

As for why the dates were in different formats, I have no idea. You
should see the rest of the workbook!


Richard Buttrey wrote:
On 31 Aug 2006 11:27:18 -0700, "Pete_UK" wrote:

No, all the dates are consistent with mm/dd/yy format - most are for
April, but some are for Feb, March and May.

Pete

Mea culpa

Quite correct now that I look again.
Put it down to a UK centric view of life where something like 04/28/06
looks odd to these old eyes.

:-(

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________