Forum Discussion

ahmedhafeez000's avatar
ahmedhafeez000
Copper Contributor
Sep 08, 2023

excel 360 language problem for old excel sheet.

i have problem with the old excel sheets 2016 or older when i use the same vb function the Arabic language appears in strange letters even if i changed the region setting for Arabic area. the formula reads Arabic but never run or give Arabic letter in the work sheet, the problem also appears in the windows notepad, any Ideas.??

excel
Macros and VBA

2 Replies

Sort By
  • tinglin's avatar
    tinglin
    Copper Contributor
    Nov 21, 2024

    REALLY helpfull!

    I changed the font and Arabic contents all showed correctly in the cells.

    I'v been confused few hours >_<

    Thank you very much~^^

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Sep 08, 2023

    ahmedhafeez000 

    If you are experiencing issues with displaying Arabic characters correctly in older Excel sheets (2016 or older) despite changing the region settings, it might be related to the encoding or font settings within the spreadsheet itself. Here are some steps you can take to resolve this issue:

    1. Check Font Settings:
      • Open the Excel sheet with Arabic text.
      • Select the cells containing the Arabic text.
      • Right-click and choose "Format Cells."
      • Go to the "Font" tab and make sure that a font capable of displaying Arabic characters is selected (common choices are Arial, Times New Roman, or a dedicated Arabic font). Ensure that the font selected supports the Arabic script.
    2. Character Encoding:
      • Sometimes, the character encoding of the text in the spreadsheet might not be recognized correctly. Try changing the character encoding settings.
      • Select the cells with Arabic text.
      • Go to the "Data" tab, and choose "Text to Columns."
      • In the Text to Columns Wizard, choose "Delimited" and click "Next."
      • On the next screen, you can choose the character encoding. Try different encoding options (e.g., UTF-8 or Windows-1256) to see if the Arabic characters are displayed correctly.
    3. System Language Settings:
      • Ensure that your Windows system language settings are configured to support Arabic.
      • Go to "Settings" > "Time & Language" > "Language."
      • Add the Arabic language if it's not already added and set it as your preferred language. Make sure the "Regional format" is also set to Arabic.
    4. Excel Language Preferences:
      • In Excel, go to "File" > "Options" > "Language."
      • Ensure that the language preferences are set to Arabic or match your requirements.
    5. Check the Workbook's Compatibility Mode:
      • Older Excel files might be opened in compatibility mode. This can sometimes cause issues with displaying characters correctly.
      • Save the Excel file in a newer format (e.g., .xlsx) to ensure it is not running in compatibility mode.
    6. Check Windows Font Settings:
      • Sometimes, issues with displaying characters can be related to font settings at the system level. Ensure that your Windows fonts are installed correctly and are not corrupted.
    7. Install Arabic Language Pack:
      • If your Windows installation does not include Arabic language support, you might need to install the Arabic Language Pack. This can help ensure that all Arabic characters are displayed correctly.
    8. Software Updates:
      • Ensure that both Excel and Windows are updated to the latest versions, as updates often include fixes for character display issues.
      •  

    The text was created with the help of AI

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark them as helpful and like it!

    This will help all forum participants.

Resources