Wrong result when typing in excell,type in Indonesian display in Engli


  1. Posts : 22
    windows 7 ultimate 32bit
       #1

    Wrong result when typing in excell,type in Indonesian display in Engli


    I work on windows 7,when I run excell application,I have something wrong.. I go to cell A1 and I type "TEH" in indonesian language mean "tea",but in the cell A1 the display result is "THE". Itry type in another cell ,the result just same. Can some on help me ??
      My Computer


  2. Posts : 7,730
    Windows 7 Ultimate SP1 64-Bit
       #2

    We can if you give us more information.

    Which language did you use when you installed Windows?

    I take it you are aware of the fact that the Indonesian language is not included in the Windows 7 Ultimate language packs?
      My Computer


  3. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #3

    No problem, easy solution.

    You are using the Excel Autocorrect function: Replace text as you type. For English, with this function enabled at the default settings, "teh" is auto corrected to "the".

    Wrong result when typing in excell,type in Indonesian display in Engli-excelautocorrect.png

    To "fix" this in Excel 2010:

    > Click the File tab
    > Click on Options
    > Click on Proofing in the Excel Options window
    > Click the Auto Correct Options... button

    To KEEP the AutoCorrct Replace text as you type option but NOT for "teh":
    > Keep Replace text as you type selected (checked)
    > Scroll down to and select "teh"
    > Click the Delete button
    > Click the OK button
    > Click the OK button

    To disable all Replace text as you type:
    > Deselect (uncheck) Replace text as you type
    > Click the OK button
    > Click the OK button

    Regards,
    GEWB
    Last edited by GEWB; 17 May 2012 at 21:47.
      My Computer


  4. Posts : 22
    windows 7 ultimate 32bit
    Thread Starter
       #4

    Thanks GEWB,now solutions finalized,God bless you
      My Computer


  5. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #5

    You are most welcome.

    Regards,
    GEWB
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:17.
Find Us