General discussion
August 5, 2002 at 05:30 AM
engineman

How do you remove decimals in excel

by engineman . Updated 24 years ago

I have a spreadsheet with about 120 thousand rows of numbers in one columb.

The number looks like this 8408.99.99.10
I want to remove the decimals from the number using a macro or something else to make the number in the cell look like this 8409999910
I then can take the numbers out of the excel sheet and feed them into an AS400 file but again I need to get rid of the decimals.

the format of the cell it Text.

and again I have about 120 Thousan number in one row that I need to change plus I have other data in the spreadsheet in other columbs too.

So my question is How can I take the decimals out but leave the numbers in place?

Thank you for any help you can give.

This discussion is locked

All Comments