ExcelBanter - 8-10 turns in 8 oct

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 8-10 turns in 8 oct (https://www.excelbanter.com/excel-discussion-misc-queries/185622-8-10-turns-8-oct.html)

CJP

8-10 turns in 8 oct

how can I stop 8-10 turning into 8 oct in excel 2007 ?

Pete_UK

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 ?

All times are GMT +1. The time now is 05:13 PM.