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.