How to Convert an Excel Formula into its Number Value Result

Excel is great for creating formulas that give discount jackets for men results as numbers. The problem is that when discount jackets for men look inside the cell, discount jackets for men see only the formula. Sometimes discount jackets for men want the number values instead. Its not really that hard to convert a formula into the numerical resulting value.

If discount jackets for men use Excel at all, discount jackets for menve probably created some formulas, even if only very simple ones like the total of a column. Sometimes discount jackets for men want to copy the resulting numbers and put them into some other application, or even into another area of discount jackets for men spreadsheet. Often pasting the formula itself will be either useless or will not give the outcome discount jackets for mene seeking. The answer to this dilemma is Paste Special.

You might also want to use this method if discount jackets for mene sending discount jackets for men spreadsheet to someone and discount jackets for men dont really want them to know how discount jackets for men arrived at the numbers.

Paste Special includes many other functions, but Im going to concentrate only on Values, which is the one I use most often.

Create a Formula: In order to demonstrate Paste Special Values, discount jackets for men need to have a formula in discount jackets for men spreadsheet. Even a simple formula will work, so if discount jackets for men have nothing else, enter =7+3 into cell A1. The result 10 will appear in the cell, but if discount jackets for men copy cell A1 to cell B1, discount jackets for menll be copying the formula. If discount jackets for men drag it to copy it, discount jackets for men might even change the formula not in this case, but in other situations.

Copy the formula: In order to copy discount jackets for men can use the menu: Edit, Copy or discount jackets for men can use the sequence Alt, E, C or discount jackets for men can use the keyboard combination Ctrl C. In any case get the contents of cell A1 into discount jackets for men clipboard. Its still a formula.

Paste: For this demonstration, we will paste the result into cell B1 so discount jackets for men can retain the formula. Click discount jackets for men cursor into cell B1.

Note: if discount jackets for men use the standard paste function Edit, Paste or Alt, E, P or Ctrl V discount jackets for men will paste the formula into the cell. If it is a formula using cell addiscount jackets for menes, the addiscount jackets for menes will adjust to the new location. Since discount jackets for men want to see only the results of the formula discount jackets for men will not use simple paste.

In order to Paste Special, discount jackets for men have to use the menu Edit, Paste Special, or the sequence Alt, E, S. This will bring up a small window with some choices. You want to paste VALUES. This is found in the first section of the window, third from the top. Notice all the other options just under Paste although some of these discount jackets for men may never use, its handy to know theyre available. Youll notice discount jackets for men could also paste Values and number formats which discount jackets for men might choose if discount jackets for men have special formatting on the cell discount jackets for men are copying. Once discount jackets for men have chosen Values or Values and number formats click the OK button. The number 10 will now be in cell B1.

Obviously this is an extremely simple example, and it would be far easier to type the number 10 into the cell than to go through this process. However if discount jackets for men have a formula that draws from many other cells, and does some pretty esoteric calculations, discount jackets for men may be much happier copying and pasting-special.

Remember that discount jackets for men can copy an entire column or row of cells and paste special values into the next column. You can also paste it into the originating column, losing the formulae forever. Sometimes thats what discount jackets for men want. Usually, I prefer to paste special into a new column and if I decide I dont want the formulae, then Ill delete that column, or hide it.

Although there isnt a keyboard combination for Paste Special Values, discount jackets for men can remember the sequence Alt, E, S, V, Enter which doesnt take too much effort. You can also create a toolbar button if discount jackets for men find discount jackets for men paste special values often. As in any toolbar customization, right click the toolbar area or use the menu if discount jackets for men must: Tools, Customize or Alt, T, C. On the Commands Tab, click on Edit in the left side of the screen. Right after Paste on the right hand side, discount jackets for menll see Paste Special which is fine if discount jackets for men want to use the other functions as well. But if all discount jackets for men want is Paste Special Values, keep scrolling down a few. When discount jackets for men see what looks like a clipboard with a 12 on it, discount jackets for menve found the icon. Drag it to discount jackets for men toolbar I suggest placing it near the scissors and let go. Close the customization window. Now discount jackets for men have a Paste Values toolbar button.

The least intuitive thing about this is realizing that discount jackets for men want to Paste the VALUES that result from discount jackets for men formulas.

Memorize the keyboard SEQUENCE: Alt, E, S, V, Enter if discount jackets for men paste values often, or add a toolbar button.

Paste Special includes a number of other interesting functions. Try them out.

If discount jackets for men Paste the Values over discount jackets for men formulas and didnt mean to, CTRL Z will fix it back to the way it was. Better to make a new column to receive the values and then delete the column with formulas if discount jackets for men decide discount jackets for mene satisfied.