| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiply/ Round by 1000
I have a column which I would like multiply by 1000 within the same column.
Basically this data is used in a vlookup in another sheet, so I cannot move the data or use a formula. I was hoping to use a Custom Format. Example 15 changed to 15000 45 changed to 45000 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiply/ Round by 1000
Vix
In a cell out of the way enter 1000, then copy it. Now select the range you want to change and instead of paste, do paste special and then select multiply, and okay out. Go back and clean up the cell with 1000 in it and you are done!!!! Mike Rogers "Vix" wrote: I have a column which I would like multiply by 1000 within the same column. Basically this data is used in a vlookup in another sheet, so I cannot move the data or use a formula. I was hoping to use a Custom Format. Example 15 changed to 15000 45 changed to 45000 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiply/ Round by 1000
Why not just use
=VLOOKUP(cell*1000,lookup+table,3,False) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Vix" wrote in message ... I have a column which I would like multiply by 1000 within the same column. Basically this data is used in a vlookup in another sheet, so I cannot move the data or use a formula. I was hoping to use a Custom Format. Example 15 changed to 15000 45 changed to 45000 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiply/ Round by 1000
Thankyou Bob and Mike for your help, These solutions both worked. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply A by 1000 record results in B | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| Multiply one cell by a factor and make that result round | Excel Worksheet Functions | |||
| Function Help | Excel Worksheet Functions | |||
| Amortization Schedule | Excel Worksheet Functions | |||
Linear Mode
