Eat whole foods: Whole foods are foods that havenât been tampered with, in the lab or the manufacturing plant. The foods you eat on this plan are straight from the farm: whole fruits and vegetables, whole grains, grass-fed and free-range meats, low fat dairy products, unsalted nuts, and seeds.
You need to replace its results with values. Just follow the simple steps below: 1  Select all the cells with formulas that you want to convert. 2  Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard.  3. Press Shift+F10 and then V to paste only values back to Excel cells.
Figure 2: You can use the VALUE function to convert numbers stored as text to usable values. A somewhat simpler approach involves using the Paste Special, Multiply command. In any version of Excel, enter the number 1 in a blank cell and then copy that value to the clipboard.Next, select the range of values stored as text, right-click, and choose Paste Special, Multiply, and then OK. You can then clear 1 from the worksheet cell.Figure 3: You can also convert numbers stored as text to values by multiplying the cells by 1.The easiest way to convert a range of values to text, though, involves using the Text to Columns feature.ou can then clear 1 from the worksheet cell. Figure 3: You can also convert numbers stored as text to values by multiplying the cells by 1. The easiest way to convert a range of values to text, though, involves using the Text to Columns feature.