how can I stop 8-10 turning into 8 oct in excel 2007 ?
P Pete_UK Apr 30, 2008 #2 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
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
