urgent help with excel

N

newbie_7

Active Member
#1
#1
hi guys,

i use a spreadsheet to copy and paste support/ resistance levels. In the last column i need to calculate the quantity.
I have searched the net and done what was suggested...ie put the amount (100000) in another cell, then copy...then highlight the column you want the values in...then right click and paste special...then select divide and you're done..

problem is..i get decimal values...

eg. apollo tyres 100000/ 71.94 should be 1390 but i get 0.000719.

all other options in paste special like add, multiply ect seem to work fine.

can anyone well versed in excel tell me what i am doing wrong please?

thank you,

newbie_7
 
R

rkkarnani

Well-Known Member
#2
#2
newbie_7 said:
hi guys,

i use a spreadsheet to copy and paste support/ resistance levels. In the last column i need to calculate the quantity.
I have searched the net and done what was suggested...ie put the amount (100000) in another cell, then copy...then highlight the column you want the values in...then right click and paste special...then select divide and you're done..

problem is..i get decimal values...

eg. apollo tyres 100000/ 71.94 should be 1390 but i get 0.000719.

all other options in paste special like add, multiply ect seem to work fine.

can anyone well versed in excel tell me what i am doing wrong please?

thank you,

newbie_7
Click to expand...
I have no idea about Excel, but would like to say that it would be easier to get help if you can attach the Excel File you have created and allow someone expert in it to rectify and post it or suggest the corrections!!
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
R Need help with AFL for Exploration - Urgent Advanced Trading Strategies 1
R URGENT help needed - Historical Unadjusted Price Data Equities 12
I New options trader, need urgent help Taxation Matters 2
R Help urgent need afl code for this idea Seminars & Tutors 0
D Urgent help needed in ploting Date in Metastock Exploration MetaStock 5

Similar threads