Translations:Faq/Calc/How to convert number text to numeric data/9/en

From The Document Foundation Wiki
Jump to: navigation, search

If your data resulted from a CSV file import, you may not have noticed that in the import dialog you can select the import locale to match the locale of the data. This helps to recognize decimal and group separators, currency symbols and day and month names in dates to yield proper numeric data. Also, some dates and currency formats are only recognized if the option Detect special numbers is activated (which then again might convert some text to numeric where conversion is not wanted, hence the option).