0
How can you identify if a cell in Excel contains a number as opposed to a formula?
Wiki User
∙ 14y ago
There are a few things you can do. Go to the Tools Menu, then pick Options, the View and down near the bottom left there is a tickbox beside Formulas. If you tick it and then click OK, all your formulas will be displayed. One problem is that it will widen out some of the columns in order for the formulas to show properly. So if you don't want that to happen and are just interested in seeing one particular formula, then to see an individual formula, just click on the cell and the formula will be shown in the formula bar near the top of the screen. Another option is to press the F2 key when you are on the cell and it will show the formula in the cell.
There is also an option to select cells that are formulas. Open the Edit Menu and click Go To. Then click Special. There is an option there that you can click that will highlight the cells that have formulas.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
The chemical formula for h20 contains how many water molecules?
It contains 6.023 x 1023 molecules of water. the number is called Avogadro's Number and it is valid under STP conditions
How many hydrogen atoms are in 6.00 mol of ammonium sulfide?
The formula unit for ammonium sulfide has the formula (NH4)2S. This formula shows that the formula unit contains two ammonium ions, each of which contains four hydrogen atoms. The total number of hydrogen atoms is therefore 8.
Formula to identify the no. of games in single elimination?
G=n-1, wherein, n stands for total number of teams.
What tells what elements a compound contains and the exaxt number of each element in a unit of that compound?
a chemical formula
The number 2 in the formula h20 tells you that each unit of this compound contains two?
Hydrogen atoms
What mass of sodium chloride contains 4.59 exp24 formula units?
The gram formula unit mass of sodium chloride is 58.443, and every gram formula unit mass contains Avogadro's Number, 6.022 X 1023 formula units. Therefore, the mass sought is 58.443 X (4.59 X 1024)/(6.022 X 1023) or 445 grams, to the justified number of significant digits.
Elements a compound contains and the exact number of the atoms of each element in a unit of that compound is called what?
That is called a formula.
Is it possible to insert a number into a Microsoft excell cell with a formula already in the cell automatically generating an answer without having to write the formula everytime?
If a formula is in a cell and a number is entered into the same cell, then the formula will be gone and replaced by the number. You can enter a number in a cell that is referenced by a formula in another cell. The cell with the formula in it will update when the number is entered into the other cell. Say you change the value in A2 and the cell A3 contains the formula: =A2*10 Then the total in A3 will update when any change in A2.
How do you identify the slope and y intercept of the line?
we use the formula y = mx + b where m is the slope and its the number multiplied by x, any other number is the y-intercept
How do you identify the number of jewels in a watch?
The number of jewels in a watch refers to the number of individual gears it contains. Other than opening it and counting, you may be able to look up the number by the make and model of the particular watch.
How to identify a 1986 Mazda 2000 F engine as opposed to a 1987 Mazda 2200 F2 series engine?
where the engine number is located it will have FE for 2000 and F2 for 2200
When trying tp identify a hazardous material by truck'?
Shipment contains a mixed load of hazardous materials
