| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
8-10 turns in 8 oct
how can I stop 8-10 turning into 8 oct in excel 2007 ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turns numbers into decimals. | Excel Discussion (Misc queries) | |||
| 7-11 tunrs to 11-Jul turns to 39274... Why? | Excel Discussion (Misc queries) | |||
| Why number 8 turns into a 0? | Excel Discussion (Misc queries) | |||
| Bug? Autocalculation turns itself on... | Excel Discussion (Misc queries) | |||
| blank cell turns to 0 | New Users to Excel | |||
Linear Mode
