Enter formulas containing right-to-left text in worksheets
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.