View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 8-10 turns in 8 oct

If you are typing this in, then add an apostrophe to the beginning,
i.e. type it as:

'8-10

and it will be treated as text.

Alternatively, pre-format the cell as text before you type it in.

Hope this helps.

Pete

On Apr 30, 11:07*am, CJP wrote:
how can I stop 8-10 turning into 8 oct in excel 2007 ?