Hello. I have 3 columns in my workbook. The second column labeled "avg. vol" everything is acually supposed to be 1000 times bigger. For example, B2 is suppose to be 5,064,000. How can I make so all the numbers in this "avg vol" column are 1000 times bigger? Also this data is coming from a DDE server.
Hi zbojnik,
Welcome to the forum.
Follow the steps:- type 1000 in a empty cell, copy that, now select the column to be multiplied, do paste - special- multiply, press ok. done
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Put 1000 in a spare/free cell. Copy the cell.
Now select the range/column you want to increase and Paste Special | operator = multiply. Then delet the contents of the cell with the 1000 in it.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
It kind of worked. Some cells have zero in them now.
Is there a refresh button or something?
Ok.. what was there before zero ?
Can you upload a sample workbook.. ? thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Maybe you better post an excel(example) instead of a jpg.
Of course (without confidentional information).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thats a good idea.Originally Posted by oeldere
Edit: I dont think it will work because the data is coming from DDE...
Is there a way to make it so anytime I put a new number in a specific column, for example the avg vol column, it multiplies the value by 1000?
Like when I put the 1 in B2, can I make a rule where any number I put in there automatically gets multiplied by 1000? Or is this something for VBA?
I got it to work thanks. Just had to do a DDE refresh.
Have you tried changing the formula in the cell...
=(STIDDE|Q!'GGP,15')*1000
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks