LTR Right-to-left mark VBA in an excel file data

[FaHaD626]

Hi

I have an Excel file data for employees

I need to program the columns to be [FONT=Arial, Verdana, Geneva, Helvetica, sans-serif]Right-to-left mark for Arabic numbers and Names and [/FONT]Left-to-right mark for English numbers and Names[FONT=Arial, Verdana, Geneva, Helvetica, sans-serif] .
is there any VBA code to do that for the entire Sheet .

in order to let Word recognize the Arabic letter & numbers from Excel when I use Mailing system from the Word.

Thanks

[/FONT]

 

[FaHaD626]

Understanding formula entry in Excel with right-to-left features is slightly more complex than understanding text entry, especially because you have the ability to enter both right-to-left and left-to-right text in formulas. Here are a few pointers to help you:
· Formulas appear left-aligned in the Formula bar and cells, with left-to-right reading order, for both right-to-left and left-to-right worksheets.
· When a function is inserted in a formula (Function command, Insert menu), the arguments can contain bidirectional text.
· The reading order and alignment of formula results depend on the reading order and alignment chosen for that cell. The default settings for reading order and alignment are Context and General, respectively.
· reading order The visual order in which characters, words, and groups of words are displayed. English and most other European languages are displayed in left-to-right order and Hebrew, Arabic, Persian, and Urdu are displayed in right-to-left order.Understanding formula entry in Excel with right-to-left features is slightly more complex than understanding text entry, especially because you have the ability to enter both right-to-left and left-to-right text in formulas. Here are a few pointers to help you:
· Formulas appear left-aligned in the Formula bar and cells, with left-to-right reading order, for both right-to-left and left-to-right worksheets.
· When a function is inserted in a formula (Function command, Insert menu), the arguments can contain bidirectional text.
· The reading order and alignment of formula results depend on the reading order and alignment chosen for that cell. The default settings for reading order and alignment are Context and General, respectively.
· reading order The visual order in which characters, words, and groups of words are displayed. English and most other European languages are displayed in left-to-right order and Hebrew, Arabic, Persian, and Urdu are displayed in right-to-left order.

how to convert numbers from English visual to Arabic visual

Thanks