Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vix Vix is offline
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Vix Vix is offline
external usenet poster
 
Posts: 9
Default Multiply/ Round by 1000


Thankyou Bob and Mike for your help,
These solutions both worked.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiply A by 1000 record results in B Mother Goose Excel Worksheet Functions 3 January 25th 06 08:36 PM
Round whole numbers up and down JoeBed Excel Discussion (Misc queries) 4 July 5th 05 05:21 PM
Multiply one cell by a factor and make that result round Machel_C Excel Worksheet Functions 7 March 15th 05 08:04 PM
Function Help Steven M. Britton Excel Worksheet Functions 0 December 9th 04 03:33 PM
Amortization Schedule Steven M. Britton Excel Worksheet Functions 0 December 8th 04 04:23 AM


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"