View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Anthony D Anthony D is offline
external usenet poster
 
Posts: 78
Default Formatting help needed

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