You have a column of data that looks like numbers, but Excel treats it as text.
Data import: Often, when importing data from another program or a CSV file, Excel interprets numbers as text.
Incorrect cell format: The cell may be formatted as "Text" instead of "Number", "General", or "Currency".
Invisible character or space: There may be a blank space, an apostrophe (') or another non-numeric "invisible" character preventing Excel from recognizing the value as a number.
Different regional number format: The data may come from a system that uses a dot as the decimal separator, while the Excel is set to use a comma, or vice versa.
Input Data (Paste here)
Output with Comma Decimal
Use this option if your original input had a **dot as the thousands separator** and a **comma as the decimal**.
Output with Dot Decimal
Use this option if your original input had a **comma as the thousands separator** and a **dot as the decimal**.