Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Rounding is MS Excel?
I know how to round using formulas, but can rounding be done without using individual formulas? Like Round items in place.
I have an excel file that goes from A1 to ET917. Each cell has a decimal in it that I want wounded down to 6 points. I would like to be able to do this without creating a new column next to each column to use the rounding function. I tried out the copy/paste special but was unable to find anything of use there.
Does anyone know an easier way than using new columns for each column combined with a formula? There are 150 columns, possibly 10 different files.
Thanks!
Sorry, I didn't mention this before. I need the text to be the real value, not just for display.
Thank you for the answers you have already given me, I apologize for not mentioning that earlier.
3 Answers
- mikea_vaLv 61 decade agoFavorite Answer
Highlight your cells
Click on Format then Cells
Little box opens up, select Number.
It will show to the right "Decimal places" with a box. Change the number in the box to however many decimal places you want.
Hit OK
- voyagerLv 61 decade ago
Since you know how to round, do the following.
Copy all the data to a new sheet
Then give the round function in the first cell in that new sheet with reference to the original sheet and copy that to all the other cells.
(ex- =ROUND(Sheet2!A1,6))
If you want those data in the original sheet, just copy it and paste as values in the original sheet.
- K In the HouseLv 41 decade ago
set your cell format to display only 6 decimal places.
Format
Cells ...
Category (number)
Decimal Places (set to 6)
OK
