Keresés

Új hozzászólás Aktív témák

  • Agyasima

    őstag

    válasz Agyasima #22278 üzenetére

    Lejárt a szerkesztési idő, de találtam választ a kérdésemre, bár megoldást nem. A lényeg, hogy ezt a "feature"-t nem lehet kikapcsolni sehogy.

    MS fórumokon találtam:
    So let me get this straight. Instead of coming out and stating the answer ("No, you can't simply turn the auto correct off"), you avoid answering the question, and state 1) How he is wrong for even wanting to do it in the first place, and that despite the inconvenience, Microsoft knows better then him and is forcing him to use workarounds, and 2) How to implement these workarounds, despite the fact that he clearly states in his question that he knows of them already.

    3/88 is NOT a date! (Excel changes it to 3/1/88) If you want to get technical about it, 1/4 is not a date either (nor a number), its a text string. It is inconsistent to change 11/4 into 4-Nov (11/4/2010) while 111/4 remains unchanged. What's the difference between those two text strings? One character. It is simple arrogance to assume that because a text string fits into a common format, that it must be interpreted as that format WITHOUT GIVING THE SIMPLE OPTION OF TURNING THIS AUTO-FORMATING OFF! It is frustrating that this happens. It is even more frustrating to know that it is trivially simple to include this as an option, and the reason that this was never included as an option is pure arrogance.

    Since this question was never officially answered, I will ask it again:

    Is there a way to turn off the auto-formatting "feature" in which Excel automatically changes anything that it thinks looks like a date into a date (registry hack, software patch, ANYTHING).

Új hozzászólás Aktív témák