what is value? in the computer system excel?
490179
If Ed answer was not the one you liked, you may see the "Value" in Excel Help, f this is what you asked for,\nThis Value is reffered to the result of a cell function.\nMeans\nWhen you enter =4*5 in a cell this "=4*5" is the cell content, while the "20" that appears in the cell is the "Value" of this cell\n\nHope this is what you asked for..\n\nXLMan
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
883420
=A1+B1 for cells \nand for columns you could do \n=SUM(A1:A10)\n\nrows could be \n=SUM(A1:f1)
1103350
excel is not that usefull for this. You basically have to write a VBA program that will go like this:\n\nif cell-value=111222 then cell-value="johnny"\n\nand so on for every contact you have. While thi is not hard there are better ways to do this. There are Address book programs that let you search by any field.
90752
Hi.  Like you, I too miss the days of the Lotus macros/scripting.  Lotus macro language was far simpler to understand.  It was so intuitive.  I tried writing scripts in Excel the first few years after Microsfot conquered the office space (~1994-1998), and after hours upon hours of trying to understand its heiroglyphics in an attempt to create a macro for a repetitive task that would have taken me ~60 second to write in Lotus, I gave up and have since only been tempted into this highly cryptic world on a handful of occassions.   I have little idea still of what I am doing in teh Microsoft Excel Macro Edior.  However, I think I do at leats kmow how to bang out something to do what wish.  Try this:\n\nSub Macro1()\n    var1 = ActiveCell.Value\n    ActiveCell.Value = "'" & var1\n    ActiveCell.Offset(1, 0).Select\nEnd Sub\n\nI think it does exactly as the keystrokes you described does, except it sounds as though you may want one more "DOWN" command, i.e., "ActiveCell.Offset(1, 0).Select".\n\nHope this helps.
518814
Excel's Biggest attribute... is to CREATE and ORGANIZE data for reporting.\n\nMy EXCEL REPORTS are "DA-BOMB"... because you can reformat, shade, color... and take the data and make it not only efficiently arranged... but ATTRACTIVE as well.\n\nYou can change sizes, and fonts, center, merge cells and create boxes.  All the things you need to make a sharp report.   \n\nThe professionalism of your report is ONLY BOUND by your imagination... not so much EXCEL.\n\n\nGood luck
1171526
A category of values is also called a column
518763
Excel (in windows) has a lot of templates set up for budgets, balance reports, ammoritization reports, etc...
1055911
To put the formulae into Excel,  make a cell and call it 'X'.  Do not put 'X' into the cell.  This cell will be where you place the value for x.  Ie, if x=2, then put 2 in the cell for 'X'.\n\nFirstly, I am not sure what the '+ 2E' means, I have interpreted it to mean 'x10^2', ie, 100, 10 squared.  If this is wrong, you will have to change the formulae accordingly.\n\nWe will assume the cell for 'X' is A1.\nThe first formula, y=234x+2E+06, is written, into a new cell:\n'=((234* A1) * 100) + 6'\nThe other is:\n'=((546 * A19) * 100000) +1'\n\nThe other answerers have helped out with how to find out which one grows faster.  Ie, y = mx + b.
855738
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.
148423
What do you mean by value?  Economic, societal, etc...\n\nWhat do you mean by alternative?  \n\nI don't believe that you can get a useful answer unless you are more specific.  Please add more detail, and I'm sure you'll receive educational replies.
881302
Obviously depends on what you're using it for.  Some easy ones:\n\n* Formula updates - can do hours of manual calculations for you automatically in a second, and redo them if a base value changes.\n\n* Sorting - can be sorted on one or more columns, allowing you to easily rank data or create an alphabetical list.\n\n* Cut/Paste - changes/additions/deletions are all relatively painless, whereas on paper they might make you redo the entire thing.
221125
Computer software (or simply software) refers to one or more computer programs held in the storage of a computer for some purpose. Program software performs the function of the program it implements, either by directly providing instructions to the computer hardware or by serving as input to another piece of software. \nen.wikipedia.org/wiki/Computer_software
33456
lotus is an older program. excel is best. but annoying when it comes to formulas.
970192
I thought I was pretty handy with excel, but I have no idea what you're asking! Do you mean the options pop-up you get if you right-click on a cell? Or Insert > Function? (on the pull-down menu, or click on the 'fx' button just below your toolbar/s). Perhaps if you clarify your question you might get a more helpful answer than I feel I can give you.
737614
Open MS Excel\nin any cell write\n=SQRT(22/7)\nthe answer would be 1.7728105208558400
779191
Excel is a spreadsheet - by definition it is NOT a database.\nWhat do you mean by "parts" - you can add as many sheets, as you want, to an existing (or new) spreadsheet.