[Solved] Excel Curiosity

    I accidently discovered a funny thing in Excel 97 and 2000 (and perhaps other versions.


    Type (with no spaces) the letters
    thisyear
    into an excel cell and enter. Excel will automatically put a space between the s an y to show
    this year
    I found this out when I defined a name as thisyear and then tried to refer to it.


    Any ideas as to why Excel is doing this?

    Hi Derk


    It is common throughout Office products. I think it is an auto spell check option as it does exactly the same in Word.


    It can probably be disabled.


    HTH


    Dave

    You ain't seen me......right!

    Hi Derk -


    It's Tools / Autocorrect


    Toggle "Replace Text as you Type" off to disable.


    (Sometime it can be a real pain when it keeps trying to "fix" your input for you . .:mad: )


    ....Ralph

    rem1224's fix works, but it is curious that without the AUTOCORRECT fix in place, Excel does not correct "thismonth" or "thisday"


    EDIT: Nevermind: I remembered to check the autocorrect list and thisyear was in there. Wonder why Microsoft singled this one out for special attention?

    lastyear and thisyear are on the Replace: With: list in autocorrect.


    thismonth and thisday are not. Guess M$ only thought people would type year in error....:biggrin:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login