In excel how do I round an entire column to the nearest tenth?
103650
Highlight the entire column (click on the letter at the top), hit "format/cells" select the number tab and select number in the menu, then make it 1 decimal place.
388002
What you need to do is take the numerator and subtract the denominator in a loop until the remaining numerator is less than the denominator while counting the number of times you do the subtraction.  You  will then have a whole number result with a remainder.  If you need to get decimal places then multiply the remainder by 10 and repeat the original process for the 1/10ths place and then repeat this process for each decimal place that you need.
331746
first of all you need to decide your frequency bins i.e. do u want to calculate frequency against each no from 1 to 100 or u want to have ranges i.e.\neither u want your output like\nPercentage                       Frequency\n       1%                \n       2%\n       .\n       .\n       .\n       100%\nOR\nPercentage                       Frequency\n    0% TO 10%                \n    11% TO 20%\n      .\n      .\n      .\n    90% TO 100%\nTo me the second set of output is more practical\n\nso whatever output u select , type the figures in a column (for second set of out put, simply type 10,20,30....  'coz 10 means 0-10, 20 means 11-20)\nIn the next column highlight all the rows against all the frequency bins\nSelect frequency function, enter data array which is the marks data in your sheet, enter bins array , which is the cells where u entered ur bins and press OK\nThis should give u a frequency fighure against the first bin only. press F2. Press Ctrl+Shift+Enter...   and u r done\n\nCheers\n\nif u still have problem, send me your sheet on, post your email address and I will send u the sheet
813501
Set cell A1 to 5:34:55 and some other cell to:\n\n=(HOUR(A1))*60+MINUTE(A1)+ IF(SECOND(A1)>30, INT(1+ SECOND(A1)/60), SECOND(A1)/60)
738595
Try this:\nRange("a1").Select\nc_value = Trim(ActiveCell.Value)\nmsgbox ("You have " & c_value & " cookies")
470569
The formula would be: =IF(A2="A", 10)\n\nThis would be pasted into another cell, like B2 for example.  Thus, if A2 is A, then B2 would display a 10 - if it is not, it will display FALSE.\n\nIf you don't want FALSE to appear, change the formula to: =IF(A2="A", 10, 0)  You can substitute the value of 0 for whatever you want the cell B2 to display if A2 is not A.
344168
Put number in double quotes. For example, "2.03" will be regarded as text by excel.\n\nOr select the cells you want the numbers to be text, then right click, select "Format Cells", select "Text".
955614
in excel you would use formulas such as =a1*3 in each cell to make the effect work from a starting number.  In HTML, you would actually use an XML table and/or some kind of scripting such as vbscript or javascript.
741529
Divide the top # by the bottom #.  Then multiply by 100
188941
you can use the isNaN function. If the given text is whole number, then Math.round(n)=n right? So, here is the function\n\nfunction get_type(txt){\nvar type;\nif(!isNaN(txt)){\nvar rnd = Math.round(txt);\nif(rnd==txt){\ntype="wholenumber";\n}\nelse\n{\ntype="decimal";\n}\n}\nelse\n{\ntype="char";\n}\nreturn type\n}\n\nThis function returns "wholenumber" if whole number, "decimal" if decimal, or "char" if character.\n\nHOPE That helps
789077
in excel all you have to do is to put = before any equation you want to solve and then press ok \nyou can use squares instead of the no.s
606125
sort the data by cell phone number\n\ninset a column to the right of the number column.\n\nin the first cell, enter this formula:\n=if(a1=a2,1,0)\nwhere "a" refers to the column with the numbers.\n\nhighlight the cell with the formula.  copy it.\npaste is all the way down to the end of the column.\n\nhighlight the column with the formulas.  copy it.  go to the edit menu, choose paste special and choose values.\n\nsort data by the column with the 1s and 0s in it.  anything with a 1 is a duplicate.
926417
as for example we will use the number of 999. 7865433\n\nround this number to ihr nearest 10 th \n\nwe look at the digit in the 100th place : if it's less than 5 we leave the number next io it ( the digit in the 10 th place ) as it is ( we don't change it ) if it 5 or more the digit in the 10 th place becomrs one more ( let say the digit { in the 10 th place } is 5  and the digit in the 100th places is 5 or more   then it become 6 ) we we round like this we drop the rest of the digits \nwe round  to the 100th and 1000th place , any place using the above rule /\n\n69 to the nearest 10th = 70\n\n496 to the nearest 100th = 500\n\n8364 to the nearest 1000th = 8000
382118
(10^2-10^2)/10(10-10)\n= (10+10)10-10)/10(10-10)\n= 20/10 = 2
550884
I tried this in Visual Basic 2005 / .NET 2.0.  Assuming you are running a reasonably up-to-date version of VB, the functions are ...\n\nTo always round DOWN:\n\nMath.Floor(x)\n\nand to always round UP (as requested):\n\nMath.Ceiling(x)\n\nwhere x is a Double or Decimal.  The documentation below gives more details.
318310
take the percent number and put it over 100. then simplify
311874
if cell A1 has a value of 50, and cell A2 has a value of 75, and you were looking to have cell A3 have a value of 67%, you would type in cell A3 the following formula:\n\n=A1/A2\n\nwhen you press return, you should get a value like 0.666667 or something similar.  Right click on that cell, and select "format cells" from the pop-up menu.  On the number tab of the format cells dialog, select the "Percentage" category and click OK.  You're done.