Hi,

Before you get carried away with this idea consider

Jan 1 2009, Jun 1 2009 and Jul 1, 2009

In you nomenclature these would all get
J0109

That's probably a bad idea. August and April start with A, March and May
with M.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CMEknit" wrote:

I'm trying to format cells so that I can enter 'F0708' and have it display as
'F-07-08'.

Is there a way to do this? I'm totally stumped. Thanks.