In an excel spreadsheet, how do you fix a field when creating an addition formula?
399337
Highlight B5 in the formula and press F4.\n\nThis will turin it into an absolute formula $B$5 and will remain fixed.\n\nThe other thing you can do is give the cell reference a name (e.g.B5VALUE) and this can be encorporated in formulaes on any worksheet.  This is an example of a named cell reference.\n\nSee source for more details.\n\nHope this helps
752512
It is all in your cell formats.\n\nFormat your first multiplier ($30,862.23) and result as $ and your second multiplier (29.95%) as %, being sure too that you set the number of decimal point you want as well.\n\nClick in the cell and go to format cell.  \n\nYou should bet the results you want..
347199
If your speaking of the Formula Expert, this wasn't in the Crystal Reports that came with VS.Net 2003.\nYou have to use the Formula Editor.
995900
It depends on how you have your other amounts organised.\n\nIf you have a column or row that is for periodic end amounts, eg, weekly totals.  You can set up a range for these.  For an example, assume the column A holds the weekly totals.   They start from A1 and finish A52.\n\nCreate a new cell and type this formula, without the quotes:\n'=sum(A1 : A52)'\nThats it.
883420
=A1+B1 for cells \nand for columns you could do \n=SUM(A1:A10)\n\nrows could be \n=SUM(A1:f1)
321857
Use the good formula CountIF.\n\nOr\n\nYou can use also SumIf.\n\ne-mail me
186438
Check http://www-class.unl.edu/psycrs/handcomp/hc1t.PDF\n\n\nAlso, Follow this procedure:\nEnter the values of X into the designated cells, beginning in the top-most cell. After each entry, depressing the 'tab' key will take you down to the next cell in the column. After completion and verification of data entry, click the button labeled «Calculate». If you wish to perform another analysis with a different set of data: click the «Reset» button if the value of N for the new set of data is undefined or smaller; click the «Reload» button if the value of N is larger than undefined.\n\nImporting data from a spreadsheet. Within the spreadsheet application, select and copy the column of data. Then return to this page, click the cursor into the data-entry field and perform the 'Paste' operation. It is important to make sure that the final line in the data-entry field entry is not followed by a carriage return. (An extra carriage return at the end of the list will be interpreted as an extra data entry whose value is zero. Importing data via the copy and paste procedure will almost always produce an extra carriage return at the end of a column.) After the bivariate list has been pasted into the data-entry field, click the cursor immediately to the right of the final entry in the list, then press the down-arrow key. If an extra line is present, the cursor will move downward. Extra lines can be removed by pressing the down arrow key until the cursor no longer moves, and then pressing the 'Backspace' key (on a Mac platform, 'delete') until the cursor stands immediately to the right of the final entry.\n(see http://faculty.vassar.edu/lowry/t_single.html)
984379
It's when you make mistake in addition. But I won't say the sum can't be put correctly but It can be made correct by changing the sign You could change the sign from + to - . Now can I have my ten points ? Please ???!
416121
As others have said, you can enter it as text, but then you always have to enter the 0.  You can force Excel to place the 0.\n\nIn the "Format Cells" window, if you choose the "Custom" option, you can enter a variety of formats in the "Type" box.  If you always wanted a 0 to appear before the remainder of the numbers, you could enter "0" and then as many "#" signs as you expect the largest number to be.  If your largest number would be 5 digits, enter "0#####".  If you want the nubmer to have a decimal component, "0#####.###".  If you want to force the decimals to appear, "0##,###.000".  If you want the number to represent dollars, "$0##,###.00".
991056
This can be done in MS Words using Fields:\n\nhttp://word.mvps.org/FAQs/Numbering/PageNumbering.htm\n\nbut I have never been able to do this in Excel. I have tried just about any character or word inside the brackets that I could come up with, but no luck. \n\nA couple of times when I thought I absolutely needed the numbering, I pasted my charts and data into a Word document.\n\nIt wasn't perfect, but with some tweaking it was at least presentable.
738891
A simple way is to make the cell a colour until it is filled with an amount.  You can do this through conditional formating under  Format.  For example if you say Cell value is equal to 0 then  format the cell Red.  If you put in a value other than 0 the red will disappear.
230306
What hurricane is describing is using a string qualifier.\n\nFor example (in this example, replace the . with a tab):\n\n'Text column 1'. '04323221'. 'Hello'\n'Blah blah blah'. '34332321'. 'Paris'\n'Random ol&#92;' text'. '9223221'. 'Green'\n\nNotice that each field begins and ends with a single-quote. The idea is that by qualifying each field with single-quotes, Excel will import the contents as a string.\n\nThat sounds great on paper and should work in theory, but it won't, because anytime Excel sees all digits, it wants a number, even if you use qualifiers.\n\nYou have to manually set up the import in Excel to work properly, if you want those zeros saved.\n\nTo do that:\n\n1. Open Excel\n2. Use File --> Open to open your TSV file\n3. Set the Files of type drop-down to be All Files, navigate to where your TSV is saved, and open it.\n4. In the dialog box, choose Delimeted, skip any rows that need skipping, choose the right encoding and click Next\n5. Make sure Tab is chosen in the delimeters and, if you have opted to use a text qualifier, it is selected.\n6. Click Next\n7. For columns that will contain leading zeros, click on that column, then choose text for the Column data format from the radio buttons at top right.\n8. Click Finish.
921289
If you are only trimming the 0 from the front ( which is what I get from your description ) just use the RIGHT function. Add a column to the right of your data and use this formula.\n\n=RIGHT(A1,LEN(A1)-1)\n\nYou will need to change the A1 to match the reference of your first cell; then just copy the formula alongside your data.\n\nTo eliminate the formulas once the 0s are gone, just select the data in the new column, Copy, then Paste Special... over your original data. Now you can delete the new column.
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
301989
Insert -> Object -> Microsoft Equation (or Equation depending on version)\n\nIt will then bring up a pallet with formula functions.  Closing this sub window will insert the equation you create into your document.
687364
In spread sheet 1 I created the following\nSorry but the formatting is not to good.\nColumn A\n1\n2\n3\n\nColumn B\nhello\nhi\nhowdie\n\nIn spreadsheet 2 I created this\nColumn A\n1\n2\n3\n\nColumn B\n=LOOKUP(A1,Sheet1!A1:B3)\n=LOOKUP(A2,Sheet1!A1:B3)\n=LOOKUP(A3,Sheet1!A1:B3)
146941
In calculated query field:\n============================\nTotal: [Field1]*[Field2]\n\nIn a form field:\n===============\n=[Field1]*[Field2]