An example of Paste Special – Adding three zeros to numbers on Excel spreadsheet

Consider a column of Excel that contains cost values in terms of thousands of dollars but without zeroes like the image below.

How to convert these values to actual numbers? Like how to convert 13 to 13,000?

Without any Excel formula, you can multiple 1000 to all your costs with paste special. For this go as steps:

Step 1:

Type 1000 in a cell and copy. (Ctrl+c)

Step 2:

Select all your data (numbers) and go to Paste special (Ctrl+Alt+V). then do as the image below:

At last you will have all the data with three zeros at the end.

Note:

This is not an Excel formula. If you want to undo this operation you should do as the same process but select Divide.

If you are looking for business solutions for your Excel workbooks, please contact us through the Excel services page.