How to put the exponent constant in representation of a number in MS excel. We can move the decimal point.?
470266
Microsoft Excel supports both scientific notation and the engineering notation variant.\n\nEnter a number such as 12,345,678 in a cell\nSelect the cell\nSelect menu bar "Format > Cells ... > Number".\nFor scientific notation, select "Scientific" and select the number of digits of precision (say 3) and the number will reformat as 1.23E+07.\n\nFor engineering notation, select "Custom" and find the format that looks like ##0.00E+00.  The number will reformat to 12.34E+06. Engineering notation traditionally formats numbers with exponents that are multiples of 3 corresponding to thousands, millions, billions, etc.\n\nI don't know of a way to select an arbitrary constant for the exponent.  Try reading the Microsoft help.
358817
- Open MS-Excel;\n- Start adding all the equations you want;\n- Save the file once done...\n\nEquation Example:\nA simple adding equation:\n- type the number 1 in cell A1\n- type the number 2 in cell A2\n- type =A1+A2\n\nand you are done\n\nTo type, click on the cell with the mouse, then type, or double-click on the cell and type\n\nTo confirm text and exit editing it, hit the Enter button\n\n_________________________\n\nTips:\n=====\n- you can use any of the following: + - * /\n- to start an equation, it must start with the = sign\n- ^ is the power sign\n- pi is used in geometry [EX: type pi() to get its value]\n\n\nHope this helps a little...
272231
You can format the output of cout like this:\ncout << setprecision(2) << yourVar << endl;\n\nAnd if you want it to show the decimal even when it is .00, use cout << fixed << ...\n\nAnd while we're at it, if you want to make your output even prettier, you might want to make use of setw(), setfill(), and left/right...\n\nOh, and to use any of those, you need to #include <iomanip>
1099390
Use Number formatting for those cells rather than General.  The General format will force exponent for anything larger than 1e+11 (or 100,000,000,000).  I'm not sure why your number drops the 5 like you describe, but it may just be a formatting issue.  After changing your format to Number, you may have to resize your column so that, in case it does show an exponent, it will show the entire number.
888394
Every time that we move the decimal point to the left, we are dividing a number by 10. we can make up for this by decreasing the power of the exponent by 1.\n\nEvery time that we move the decimal point to the right, we are multiplying a number by 10. we can make up for this by increasing the power of the exponent.\n\n\n.0035 x 10^15 = 3.5 x 10^12\n.002 x 10^17 = 2 x 10^14\n\n7000 x 10^33 = 7 x 10^36\n\nWhen multiplying two scientific notation numbers, like\n\n(a x 10^b) * (c x 10^d)\n\nmultiply a and c, and add b and d. Use the sum as the exponent of the product.\n\nSo:\n\n(3.5 x 10^12) * (2 x 10^14) = 7 x 10^26\n\nNow we can divide.\n\nWhen dividing two scientific notation numbers, like\n\n(a x 10^b) / (c x 10^d)\n\ndivide a by  c, and subtract d from b. Use the difference as the exponent of the product.\n\nSo:\n\n(7 x 10^26) / (7 x 10^36) = 1 x 10^(-10)
810525
Move the decimal two places to the left.\n.3455
10776
Insert the value "-1" into a cell.  Copy it.  Highlight all the cells you want to change.  Right Click>Paste Special>Multiply.  This will multiply all cells by -1.\n\nYou can always just hide the row/column and create a viewable row/column that is that (-cell).
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.
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
1016721
actually, I use BCD for decimals\n\n0.264\n0010 0110 0100 (BCD)
742231
I don't understand "readability" either, but I could point out that I would replace "to the power of " with the uppercase character on your 6 key, the "^". So 4.06 x 10^5 is the way I'd do it.
1021089
Decimal is the normal way to write numbers: .00002\nScientific notation is 2x10^-5\nTo do this just move the decimal over to the right (-) an count the number of 0's you pass and put 10 to that power.  If you move the decimal to the left then the power is positive.\n\nWhy do scientist do this?  In our solar system there are some very big numbers like 360,000,000,000,000.  It is easier to just write 3.6x10^14.  There are also numbers that are very small such as in atoms.  Hope this helps.
400127
C  H   O\n.6  12   6\n\nWITHOUT DECIMAL POINT
392220
1.  Mark the applicable column or cell.\n2.  Choose "Format" drop-down menu from the top menu.\n3.  Select "Cells"\n4.  On the TAB "Number" (first TAB), choose the option "Number" (the default is General)\n5.  Select the decimal places as "2"\n6.  Click on OK\n\nAll numbers in the selected cells will now be shown with two decimal places
1186574
Format the column as "Text" instead of as "General". When it is input as a number, it is limited to the precision of an integer or double integer. When it is text, any math performed on it will be at the limit of precision, however the digits will display on the sheet.\n\nIf you are typing in numbers, you can force the cell to be treated as text by typing an apostrophe (') first.\n\nInformation about how Excel handles numbers can be found here: http://support.microsoft.com/kb/78113/en-us
167875
You can do it on Google.  Do a search on: 2^900\nThe ^ means "to the power of" and it is the shift of 6.\nIt will only give you an approximate answer because the exact answer has hundreds of digits.  It would take you many hours to "show the work" and you would probably make many mistakes because there are so many digits to copy.
792191
If you really want them to be numbers, then change the format of the cells. Use the number format "0000#" (or however many zeros you want).\n\nHowever, VLookup will not match the leading zeros in this case because the internal format of the numbers will be mathematical not textual. If you want to store the numbers as text (for instance, if they are ID numbers) then preface them with ' when you enter them. This tells Excel not to evaluate the cell.