# Converting Numbers from Thousands to Millions

#### Bruce212

##### New Member
I have typed in columns of figures in thousands (e.g, 25,550) that really should have been typed in as millions (e.g., 25,550,000) and need to be displayed that way. Is there any way to convert columns of numbers already typed in as thousands to millions? I don't just want to change formats, I want to change the numbers themselves without having to retype them in. Any advice would be appreciated

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
A quick and dirty way is to:

Add another column, put in the first cell - A1*1000. now copy it down

This will convert all the numbers to millions.

Now, click the new column number, press control c, click the old column and select Edit, Paste Special then select Values from the list

Click the new column header, press delete.

Job done!

HTH

Chris

Welcome to the Board!

You can also put 1000 in an unused cell, copy it, then highlight the range that you want to be in milions and goto Edit-->Paste Special-->Multiply.

Hope that helps,

Smitty

Nice one smitty, didn't know you could do that!

A nice trick you can pull with Edit / Paste Special / Multiply is assuming you had table of values, whether they be hardwired or formulas, and you wanted to multiply them all by a value from another cell, but leave it such that you could change that value:-

Assuming data table in A1:H100, in say cell K1 put a number, eg 1, and then in any other cell put =\$K\$1. Copy the cell you just put that in, select the table A1:H100, do Edit / Paste Special / Multiply and then delete the cell with the formula. You will now have all your cells linked to K1 and can change the value in it at will and see it reflected in changes to all the values in your table.

Another trick is to use it to coerce textual 'numbers' from text format back to numerical format. Put a 1 in a cell, ensure it is numeric, select your text 'numbers' and then paste special / multiply to convert them all.

Thanks to all. You're a lifesaver (or at least a true timesaver)!

Replies
20
Views
353
Replies
3
Views
466
Replies
3
Views
215
Replies
15
Views
420
Replies
19
Views
2K

1,203,069
Messages
6,053,351
Members
444,655
Latest member
didr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back