Formatting help needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
One way would be to use a formula and then copy/paste to value

=MONTH(G6)&" - "&DAY(G6)
 
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
 
precede it with an apostrophe '

'2 - 5

--
HTH

Bob Phillips

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