General discussion

Locked

How do you remove decimals in excel

By engineman ·
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 conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How do you remove decimals in excel

by DKlippert In reply to How do you remove decimal ...

Highlight the cells and use Edit>Replace. Put a decimal(.) in the Find box and nothing in the Replace box.

Collapse -

How do you remove decimals in excel

by engineman In reply to How do you remove decimal ...

Poster rated this answer

Collapse -

How do you remove decimals in excel

by SimGehlen In reply to How do you remove decimal ...

I agree with the above. Do the search and replace. After you have removed all the decimals, you will need to highlight the affected cells, and set the format as numeric rather than text. When the number of decimals is requested, enter zero. If you skip this step, Excel will look at the data only as text and you will not be able to use it as numeric data to execute formulas, etc.

Collapse -

How do you remove decimals in excel

by engineman In reply to How do you remove decimal ...

Poster rated this answer

Collapse -

How do you remove decimals in excel

by SimGehlen In reply to How do you remove decimal ...

I agree with the above. Do the search and replace. After you have removed all the decimals, you will need to highlight the affected cells, and set the format as numeric rather than text. When the number of decimals is requested, enter zero. If you skip this step, Excel will look at the data only as text and you will not be able to use it as numeric data to execute formulas, etc.

Collapse -

How do you remove decimals in excel

by engineman In reply to How do you remove decimal ...

Poster rated this answer

Collapse -

How do you remove decimals in excel

by engineman In reply to How do you remove decimal ...

This question was closed by the author

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums