# How to Fix Unexpected Decimals Like 61200.000000000007 When Importing from Excel

**URL:** <https://community.exploratory.io/t/how-to-fix-unexpected-decimals-like-61200-000000000007-when-importing-from-excel/3880>\
**Category:** HowTo\
**Created:** [April 8, 2025, 3:17pm UTC](https://community.exploratory.io/t/how-to-fix-unexpected-decimals-like-61200-000000000007-when-importing-from-excel/3880 "2025-04-08T15:17:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hide\_Kojima1](https://community.exploratory.io/user_avatar/community.exploratory.io/hide_kojima1/32/398_2.png) [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\
**Post date:** [April 8, 2025, 3:17pm UTC](https://community.exploratory.io/t/how-to-fix-unexpected-decimals-like-61200-000000000007-when-importing-from-excel/3880/1 "2025-04-08T15:17:28Z")

</div>

## Problem

When importing an Excel file, some cells correctly show values like `61200`, but in other cases, unexpected decimals appear — for example, `61200.000000000007` — even though the value in Excel looks like a clean integer.

## Solution

This usually happens due to how the numbers are **formatted** and **stored** in Excel.

### What’s causing it?

If your Excel cells use a custom format like:

 ![image](https://community.exploratory.io/uploads/default/original/2X/5/536fc4d6a670f2b3a22acfd3f0fb8ee32d9b7de2.jpeg)

```auto
#,##0_ ;[Red]-#,##0

```

Excel **displays** the number as an integer (with commas), but **internally** the value may still include tiny decimal fractions due to floating-point precision.

> For example, Excel might display `61,200` but store the value as `61200.000000000007`.  
> That tiny fraction doesn’t affect rounding, but it **does** show up when importing the data.

### How to fix it

To import these numbers as integers and avoid the decimal noise, follow these steps:

1. Click the **column menu** in the import preview.
2. Select **Integer** as the data type.
3. Click **Apply**.
4. Proceed with the import.

This forces the column to treat all values as whole numbers.

 ![Import Steps](https://community.exploratory.io/uploads/default/original/2X/1/135aa5896f48be6c8760b1f09a9cdc8ee6268168.png)
