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

Try changing the formatting to Text. You will need to retype it in.



"Lynne Mawson" wrote:

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

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

Hi Lynne,

You can put a single apostrophe ' before expressions that are potentially
'mathematical' e.g. they start with a number or dash (minus sign) if you
would like them to be treated as text:
'2 - 5 instead of 2 - 5

Anthony

"Lynne Mawson" wrote:

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

precede it with an apostrophe '

'2 - 5

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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