Published On: November 27th, 2015|0.9 min read|

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.


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.

Our experts will be glad to help you, If this article didn't answer your questions.

Share now:

About the Author: Hajir Hoseini

Leave A Comment


for exclusive offers and new posts.

Elevate your business efficiency and decision-making

Explore our expert Excel consulting now!

contact us

Contact us today at and speak with our specialist.