Formatting help needed

[Lynne Mawson]

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?

 

[Office Helper]

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

 

[Don Guillett]

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

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

 

[Anthony D]

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

 

[Bob Phillips]

precede it with an apostrophe '

'2 - 5

--
HTH

Bob Phillips

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