month, year as date

[Tim]

Hi Is there a way of formatting date to only show date as month year, (May
05). Using excel 2003.

Thanks TIm

 

[Arvi Laanemets]

Hi

Custom format "mmmm yy" or "mmmm yyyy" or "mmm yy" etc. I myself prefer the
format "yyyy.mm" - it doesn't mess up the record order whe the table is
sorted by this column.

 

[RagDyeR]

Custom format:

mmm yy
OR
mmmm yy
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi Is there a way of formatting date to only show date as month year, (May
05). Using excel 2003.

Thanks TIm