https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #6 from ady <adylo811...@gmail.com> --- (In reply to m_a_riosv from comment #5) > They are not importer as numbers, but text. Doesn't matter that the cell > format is standard. I want to be clear. Following the steps that I described (i.e. using "Detect special numbers"), the columns as Standard and locale as English USA (in the upper field of the import dialogue), the values are imported as numeric formatted as currency, not as text. The numeric values can be checked by Value Highlighting and by the ISTEXT() function. They are also aligned to the right by default, without having to set it manually. Having the locale as English USA helps in identifying the dot/period as decimal separator and the $ as currency, when it is used with "Detect special numbers". I have the option for "Natural sort" disabled for the sort dialogue. -- You are receiving this mail because: You are the assignee for the bug.