One way would be to use a formula and then copy/paste to value

=MONTH(G6)&" - "&DAY(G6)

--
Don Guillett
SalesAid Software

"Lynne Mawson" wrote in message
...
I have started an extremely basic sheet and only want to put opening times
of
buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using
general
in category but still get 2-May instead of 2 - 5. Can you help?
--
Lynne Mawson
Manchester