Converting a number to an integer using int

**charkins** · 05-14-2014, 04:50 PM

Hey there everyone,

Is there any fast solution to converting a number within a cell to an int?

I know you can quickly convert a number in a cell by clicking "int" on the formula ribbon and selecting another cell that has the desired data to change.

But I just need to change it in the one column. I am having a data type error with my SQL when trying to import the data into an already existing database.

Thanks!!!

**zbor** · 05-14-2014, 04:57 PM

You can write =INT(A1) (as you said)
Then copy that column and paste values into A column (for example).
Then delete additional column.

**AlKey** · 05-14-2014, 06:05 PM

You can do it in the column without any formulas.

1.Select range of cell.
2. Press Ctrl+F to open Find tool
3. In Find what type in: .? or .* (if there are more than 1 dec) then click Replace button and Replace All