Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |