Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Decimals
I have an excel sheet with data that is imported from another program, when I
veiw the info in the cell, that data has two decimals, which is fine, I then need to copy and paste this into another excel workbook, and it shows up with 7 or more decimals, and I cant not remove them, format cells doesnt work, decrease the decimal doesnt work, so I many have to retype each number, is there a better way? I use Excel 2003 Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Decimals
In a helper column enter this formula:
=ROUND(A1,2) assuming your numbers are in column A. Copy the formula down as necessary then fix the values using <copy then Edit | Paste Special | Values (check) | OK and <Enter then you can copy/paste these values to over-write the ones in column A. Hope this helps. Pete cyndi wrote: I have an excel sheet with data that is imported from another program, when I veiw the info in the cell, that data has two decimals, which is fine, I then need to copy and paste this into another excel workbook, and it shows up with 7 or more decimals, and I cant not remove them, format cells doesnt work, decrease the decimal doesnt work, so I many have to retype each number, is there a better way? I use Excel 2003 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
How do I calculate without decimals in excel? | Excel Worksheet Functions | |||
How do I remove decimals of IP address in excel? | Excel Discussion (Misc queries) |