Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying A Whole Column By 2 ??? Help
Hello, I recieve product stock list from my supplier in excell. 2 columns, A = products , B = prices I need a formula that will multiply all prices in column B by 2 so I can then easily forward stock list to my customers without revealing original values in column b. I have tried all the basic first thought ideas and none have worked. please provide help. thank you. -- joesther37 ------------------------------------------------------------------------ joesther37's Profile: http://www.excelforum.com/member.php...o&userid=30031 View this thread: http://www.excelforum.com/showthread...hreadid=497180 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying A Whole Column By 2 ??? Help
Save the file first (this one is for you)
Now type 2 in any empty cell and copy it Select all the B cell and use Edit |Paste Special-Multiply All B values are now doubled! Save file with another name (this one is for customers) Happy New Year -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "joesther37" wrote in message ... Hello, I recieve product stock list from my supplier in excell. 2 columns, A = products , B = prices I need a formula that will multiply all prices in column B by 2 so I can then easily forward stock list to my customers without revealing original values in column b. I have tried all the basic first thought ideas and none have worked. please provide help. thank you. -- joesther37 ------------------------------------------------------------------------ joesther37's Profile: http://www.excelforum.com/member.php...o&userid=30031 View this thread: http://www.excelforum.com/showthread...hreadid=497180 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying A Whole Column By 2 ??? Help
You can type the number 2 in any empty cell Then copy that cell Now select all the cells in column B that you want to double Now right click on any cell in that selection and choose Paste Special Choose Multiply and then OK -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=497180 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying A Whole Column By 2 ??? Help
Much better way of doing it than what I suggested.
I didn't realize that's how that feature worked! Thanks for sharing!!! "Bernard Liengme" wrote: Save the file first (this one is for you) Now type 2 in any empty cell and copy it Select all the B cell and use Edit |Paste Special-Multiply All B values are now doubled! Save file with another name (this one is for customers) Happy New Year -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "joesther37" wrote in message ... Hello, I recieve product stock list from my supplier in excell. 2 columns, A = products , B = prices I need a formula that will multiply all prices in column B by 2 so I can then easily forward stock list to my customers without revealing original values in column b. I have tried all the basic first thought ideas and none have worked. please provide help. thank you. -- joesther37 ------------------------------------------------------------------------ joesther37's Profile: http://www.excelforum.com/member.php...o&userid=30031 View this thread: http://www.excelforum.com/showthread...hreadid=497180 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying A Whole Column By 2 ??? Help
To make things a little easier and quicker, it pays to format the cell
containing the "2", *exactly* as you would like the column you're incrementing to look like. For example ... 2 decimals with a dollar sign. That way, when you "Paste Special" and multiply, the entire column will end up with the proper formatting. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "joesther37" wrote in message ... Hello, I recieve product stock list from my supplier in excell. 2 columns, A = products , B = prices I need a formula that will multiply all prices in column B by 2 so I can then easily forward stock list to my customers without revealing original values in column b. I have tried all the basic first thought ideas and none have worked. please provide help. thank you. -- joesther37 ------------------------------------------------------------------------ joesther37's Profile: http://www.excelforum.com/member.php...o&userid=30031 View this thread: http://www.excelforum.com/showthread...hreadid=497180 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
multiplying an enitre column. | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |