| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change input
when i put in 10-20 in a cell excel automaticaly changes it to 20 october...i
was wonderig how do i change it |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change input
Either preformat the cell as TEXT or precede the entry with an apostrophe:
'10-20. The apostrophe will not be displayed in the cell. -- Biff Microsoft Excel MVP "general question" <general wrote in message ... when i put in 10-20 in a cell excel automaticaly changes it to 20 october...i was wonderig how do i change it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change color in cell when there is input | Excel Worksheet Functions | |||
| excel input cell border change | Excel Worksheet Functions | |||
| cell input change | Excel Discussion (Misc queries) | |||
| Why does Excel change the dates I input? | Excel Worksheet Functions | |||
| Change the input in a sheet by OptBox | Excel Discussion (Misc queries) | |||
Linear Mode
