I've got a spreadsheet in Numbers which was a .xlsx
file previously. In Windows I used to have one the columns of this spreadsheet to be shown in a Farsi/Persian/Iranian font. This column is only meant to show numbers in Farsi.
When replicating this in Numbers by installing the same font I used in Windows and setting that column to use that font. However, it seems it just changes the numbers to that font, but instead of the numbers being written in Farsi numerals they are shown in the "regular" numerals like 1, 2, 3
…
I believe it's possible to just write each cell individually by changing the keyboard to Farsi, but this is an extensive column and I'd like to do this manually.
I can try to provide further details if needed. Thank you!
Best Answer
In Numbers go to:
Select
Persian
from the dropdown list for the languages and then hitOK
.That will revert your numbers as well as the rest of the locale related settings to Persian.
Voila!
(You can do the same in Excel or the rest of the Office family).
Update:
Note that this method will change all numbers in your file to Persian. Seems like there's no proper way of having a bilingual sheet; you need at least two sheets one in each language. Also, if you want to retain everything and only apply it to one set of numbers, then, weirdly enough, you need to type any letter in Persian, then input your number. If the global language setting of the file is on English, it'll display the numerals in English, unless you keep at least a Persian letter before the digit in the cell. This is far from ideal, but I can't seem to find another work around this.