Why is Tableau Showing ABC Instead of Numbers?

Seeing "ABC" placeholders where your numbers should be is one of the most common frustrations for anyone starting out with Tableau. The good news is that it’s almost always a quick fix once you understand why it's happening. This guide will walk you through exactly why Tableau shows "ABC" and provide step-by-step instructions to replace those letters with the data you expect to see.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does Tableau Show 'ABC' Instead of Numbers?

In short, Tableau shows "ABC" because it believes the data field you're trying to display is text (also known as a "string"), not a number. The "ABC" is simply a visual placeholder for that text data type in a table view.

This happens all the time when importing data, especially from sources like CSV files or Excel spreadsheets. A column that looks like numbers to you might contain characters that make Tableau classify it as text. This could be anything from currency symbols (like $ or €), commas in thousands (1,000), percentage signs (%), or even a single text entry like "N/A" somewhere in the column.

To understand the fix, you first need to know how Tableau categorizes your data:

• Dimensions: These are qualitative, categorical fields that you use to group or "slice" your data. Think of things like Product Category, Country, or Customer Name. They are typically text or dates, and in the Tableau Data pane, they often appear blue.
• Measures: These are quantitative, numerical fields that you can perform mathematical calculations on. This includes fields like Sales, Profit, or Quantity. They are the values you want to sum, average, or count. In the Data pane, they often appear green.

When you see "ABC," it's because a field that should be a measure (like Sales) has been incorrectly identified as a dimension (text), and Tableau is just showing you placeholder text for each row.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Tell If Your Data Type is Incorrect

You can quickly confirm if your data type is the problem by looking at the Data pane, which is typically on the left side of your worksheet. Tableau uses small icons to represent the data type of each field.

Here’s what to look for:

• Abc: This icon indicates a String (text) data type.
• #: This icon indicates a Numeric data type (either whole or decimal).
• Calendar Icon: This indicates a Date data type.
• Globe Icon: This indicates a Geographic data type.

If you see the "Abc" icon next to a field that should contain numbers (like Sales or Revenue), you’ve found your problem. You'll also notice that the field is likely listed under the "Dimensions" section at the top of the Data pane, instead of in the "Measures" section at the bottom.

The Solution: How to Change a Field's Data Type in Tableau

Once you've identified the field with the wrong data type, you have two simple ways to fix it.

Method 1: Changing the Data Type at the Source

This is the most thorough method because it fixes the data type for the entire workbook from the moment the data is connected. It's the best practice for ensuring consistency across all your worksheets.

Step-by-step instructions:

1. Navigate to the Data Source tab at the bottom-left corner of your Tableau window.
2. In the data preview grid, find the column that is causing the issue.
3. Look at the icon at the very top of that column. It will show the current data type (likely "Abc").
4. Click on that "Abc" icon.
5. A dropdown menu will appear. Select the correct new data type, such as Number (decimal) for currency data or Number (whole) for integers like quantities or IDs.
6. Return to your worksheet tab. You should see that the field has now moved from the Dimensions section to the Measures section in your Data pane, and its icon has changed to a hash symbol (#).

Now, when you drag that field into your view — for example, onto the "Text" box in the Marks card — the actual numbers will appear where the "ABC" placeholders used to be.

Method 2: A Quick Fix in the Worksheet View

If you're already deep into building a visualization and want to make a quick change, you can adjust the data type directly from the worksheet's Data pane.

Step-by-step instructions:

1. In the worksheet view, find the problematic field in the Data pane on the left side of the screen. It will be under the Dimensions section.
2. Right-click on the field name.
3. From the context menu, hover your mouse over Change Data Type.
4. A sub-menu will appear with all the available data types. Select either Number (decimal) or Number (whole).

Just like with the first method, the field will automatically update its icon and move down into the Measures section. You can now use it in your visualizations as a numeric field.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Troubleshooting: What if Changing the Data Type Doesn't Work?

Sometimes, simply changing the data type isn't enough. If Tableau still has trouble converting the field, it usually means there's "dirty" data in your column that needs to be cleaned up first. Here are the most common things to look out for.

Problem: Your Data Has Non-Numeric Characters

If your numbers column contains dollar signs, commas, or any other text characters, Tableau might fail to convert some or all of the rows, often resulting in Null values after the conversion attempt.

The Solution: Clean the data with calculated fields.

You can create a new calculated field that strips out the unwanted characters before converting the field to a number. For example, if your "Sales" field has dollar signs (e.g., "$1,200.50"), you can do this:

1. Right-click on a blank space in the Data pane and select Create Calculated Field.
2. Give your new field a name, like "Sales (Cleaned)".
3. Enter a formula to remove the character. To remove dollar signs and commas, you can nest the REPLACE function, then wrap the whole thing in a FLOAT function to convert it to a decimal number.

FLOAT(REPLACE(REPLACE([Sales], "$", ""), ",", ""))

1. Click OK. You will now have a new, clean measure you can use in your reports that is properly formatted as a number.

Problem: Dealing with Null or Empty Values After Conversion

Tableau will assign a Null value to any field that it cannot convert to a number. If 'N/A' or '-' was entered in place of a zero, that row will become null. While nulls are sometimes acceptable, you may want to display them as zero for calculations and visual clarity.

The Solution: Use the ZN() function or format special values.

• Using ZN(): The ZN() function stands for "Zero Null." If your value is Null, it returns a 0, otherwise, it returns the value itself. You can create a calculated field like ZN([Your Measure]) to get a version of your field with no nulls.
• Formatting: You can also tell Tableau how to display nulls directly. Right-click on your measure in the view, select Format..., go to the Pane tab, and in the "Special Values" section at the bottom, you can specify text to show for null values, such as "0" or "No Data."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Quick Note: When Should Numbers be Text?

It's important to remember that not all numbers should be classified as a measure in Tableau. Ask yourself: "Will I ever need to do math with this?"

Fields like Zip Codes, Order IDs, or Phone Numbers look like numbers, but you'll never need to calculate the sum of all zip codes. Treating them as numbers can cause problems, like dropping the leading zeros (e.g., "01234" becomes "1234"). For these types of fields, it’s best to leave their data type as a String (Abc).

Final Thoughts

Running into the classic "ABC" placeholder in Tableau is a rite of passage for many analysts. It almost always boils down to a simple data type mismatch where Tableau sees your number field as text. By checking the field icon in the Data pane and using one of the quick methods to change the data type from String to Number, you can solve this problem in just a few clicks.

While mastering Tableau is an incredibly valuable skill, we know that getting the data clean and telling stories can still involve a lot of these time-consuming hurdles. We built Graphed because we wanted to create a faster path from raw data to real-time insights. You can connect your marketing and sales data, then just describe the charts and dashboards you need in plain English. Graphed handles the data connections and builds the visualizations automatically, letting you skip the manual steps and get straight to answering your most important business questions.