The cell will have a green dash line around it once it has been copied to the clipboard. Copy the divisor number (cell D2 in this example) cell by using Ctrl + C or right-clicking on the cell and selecting Copy from the pop-up menu.Enter the divisor number such as 1000 into another cell.You might want to store the numbers elsewhere in your spreadsheet before using this technique! The disadvantage is that it will overwrite the original number, and the process is a bit more complicated. You can use a paste special option to divide a number by a thousand or million. This is another way to divide your numbers by a thousand or a million, but without using a formula. Use Paste Special to Format Numbers as Thousands, Millions, or Billions You may need to click on this a few times depending on how many decimal places you want to show.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |