| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i turn off auto fill?
every time i try to type "5-8", excel automatically replaces it with
"05-Aug". I've been into the options tab and turned off auto fill, but this didn't solve the problem. How can I stop this from happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i turn off auto fill?
Autofill isn't your problem, the cell you are using is formatted as a date.
Change the format to general "nia1989" wrote: every time i try to type "5-8", excel automatically replaces it with "05-Aug". I've been into the options tab and turned off auto fill, but this didn't solve the problem. How can I stop this from happening? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i turn off auto fill?
Excel is assuming your number 5-8 as date.
1. Right-click on the Column Heading (e.g. A, B, C to select entire column or made a particular selection as required) and choose Properties. 2. From General tab choose Text as Category and click Ok. Hope this help, let us know! "nia1989" wrote: every time i try to type "5-8", excel automatically replaces it with "05-Aug". I've been into the options tab and turned off auto fill, but this didn't solve the problem. How can I stop this from happening? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i turn off auto fill?
As RajKohli says, format cell as text OR input as '5-8
"RajKohli" wrote: Excel is assuming your number 5-8 as date. 1. Right-click on the Column Heading (e.g. A, B, C to select entire column or made a particular selection as required) and choose Properties. 2. From General tab choose Text as Category and click Ok. Hope this help, let us know! "nia1989" wrote: every time i try to type "5-8", excel automatically replaces it with "05-Aug". I've been into the options tab and turned off auto fill, but this didn't solve the problem. How can I stop this from happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Troubleshooting auto fill | Excel Discussion (Misc queries) | |||
| Auto Fill - working as expected? | New Users to Excel | |||
| Formula to auto fill in following month. | Excel Worksheet Functions | |||
| can I auto fill zip code column when city is typed | Excel Worksheet Functions | |||
| Auto fill option box disappeared | Excel Worksheet Functions | |||
Linear Mode
