Page 1 of 1
Changing Excel values to millions
Posted: Fri May 15, 2015 12:25 pm
by Lotus
I have a range of values in Excel that are in, for example, the following format.
78344.92
344345.00
1513.40
1560.55
4864.50
19492.50
Those are the full values, so $78.3k, $344.3k, $1.5k, etc. I want them to be in millions though, and not just displayed as millions (like Format Cell > Custom) but to actually change the raw data. So the first one would become 0.0078344, second would be 0.344345, etc.
What's the quickest way of me doing this?
Thanks.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:27 pm
by DML
Can we archive this?
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:28 pm
by That
Can you use the formula =(A1)/1000000 in another cell, click and drag down so it auto-populates all the cells with the 'millionified' values? If you need to overwrite the original values with the new ones you can just copy/paste the data (as opposed to the formula), I'm sure there's an option for that.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:33 pm
by Lotus
Yes I can, thanks Karl. Pls lock.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:34 pm
by Albert
Should it not be
=(A1)*1000000
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:35 pm
by Albert
Ignore me, I'm bad at reading.
I'm locking this so you can't mock me.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:35 pm
by That
No, that would convert it to being in units of one-millionths-of-a-pound.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:35 pm
by That
Haha, Albear can't do maths, owned. Idiot. Dunce.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:42 pm
by Dual
Albear wrote:Should it not be
=(A1)*1000000
Idiot
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 12:51 pm
by Errkal
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 2:34 pm
by <]:^D
excellent
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 2:38 pm
by Eighthours
Albear wrote:Should it not be
=(A1be@r)*1000000
FTFY.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 2:40 pm
by Moggy
We need numeracy tests for mods.
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 3:05 pm
by Albert
This...must be..what they call....rage
Re: Changing Excel values to millions
Posted: Fri May 15, 2015 3:46 pm
by Moggy
Albear is talking about rape but he is a terrible speller as well.