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?
- flavorful0
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!
- 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*