How to Display Integer Values in Excel 3D Maps Data Cards
Question details
The user needs a way to display numbers as whole integers or formatted currency within Excel 3D Maps data cards.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating an Excel 3D Map visualization where the data cards need to show clean, whole numbers instead of raw, unformatted decimal values.
- Observed behavior
- Excel 3D Maps data cards ignore custom currency or number formatting applied to cells and display long, unformatted decimal values by default.
Make sure you have editing access to the original dataset in your spreadsheet, as you will need to modify the source data before launching the 3D Map.
Use the TRUNC Function to Remove Decimal Places
Because 3D Maps cannot format numbers directly, you must use the TRUNC function in your source data to strip away decimals before creating the visualization.
The TRUNC function truncates a number to an integer by removing the fractional part of the number. This is the most direct way to ensure your 3D Map data card displays a clean integer.
Insert a new column next to the original decimal data in your Excel worksheet.
Select the first empty cell in the new column and type =TRUNC(B2, 0) (replace B2 with the cell reference of your original data).
Press Enter, then click and drag the fill handle at the bottom-right corner of the cell to apply the formula to all rows in the dataset.
Open your 3D Map and update the Layer Options to map this new integer column to your data card instead of the original raw data.

Use the ROUND Function for Accurate Whole Numbers
If mathematical accuracy is required and you need to round numbers up or down to the nearest whole integer rather than just dropping decimals.
Customize the Data Card Layout
While you cannot change the number format itself inside the 3D Map, you can customize which fields appear on the data card to utilize your newly created integer columns.
Experience Seamless Data Visualization with WPS Office
Avoid complex formatting limitations and high subscription costs. WPS Office provides a free, lightweight suite that seamlessly handles your spreadsheets and data visualizations, maintaining full compatibility with Microsoft Office files.

Frequently Asked Questions
Can I format numbers as currency directly inside the Excel 3D Maps data card?
No, Excel 3D Maps data cards do not currently support applying custom number or currency formatting directly within the add-in. You must modify the values in the source worksheet to reflect the exact characters or integers you want displayed.
Why does my 3D Map data card show long decimal numbers instead of the formatted cell value?
The data card pulls the underlying raw values from your dataset rather than their formatted appearance. If the source cell contains decimals, the data card will display them regardless of whether the cell is visually formatted to hide decimals in the worksheet.
Will the INT function work instead of TRUNC or ROUND?
Yes, you can use the INT function (e.g., =INT(A2)) in your source data. It rounds numbers down to the nearest integer, which will effectively produce whole numbers that display properly on your 3D Map data card.




