excel annoyance
- Started
- Last post
- 10 Responses
- emecks
can anyone tell me how I can multiply the values in a column by 100??
I got a CSV which when imported into excel outputs the values as 0.11 instead of 11%....
anyone?
- CALLES0
hahahahah! sorry... didnt mean to laugh... but it sucks that your have to do something in excel
- amullins0
format cells?
- ********0
Uh ... here's what you do.
In the column next to it, write this: A1*100
Where A1 equals the first column/row you want to multiply by 100.
You can copy that function down the line. Afterwards, copy the entire second column and then Paste Special with just the values in a new column ... delete the other two?
Also ... formatting the first column so it is not a percent may help as well.
...
THINK MAN THINK!
- ********0
excel makes me weep
- i dont have to use it, but i just despise its very existence********
- i dont have to use it, but i just despise its very existence
- detritus0
Excel's the one piece of software from Microsoft that I actually quite like - it gives me a handle on a field that I otherwise find quite dense and impenetrable. Nothing quite as sexy as a multi-sheet document with loads of inter-connections which, when you change one field value on the first sheet, gives you a two-year spread or something, on a different sheet. Unghf... ohhhyeaahhh... *thwapthwapthwap*
- ********0
1. select column
2. click the (%) icondid I win?
- did you read the thread first?
answer this question to see if you have won.kelpie - ?
i thought I did. maybe I'm missing something.********
- did you read the thread first?
- ********0
I love the CONCATENATE function ... and I don't care who knows it!!!!
- have you told your parents yet? do you think they'll still love you?********
- have you told your parents yet? do you think they'll still love you?