Changing Excel values to millions

Fed up talking videogames? Why?
User avatar
Lotus
Member
Joined in 2008

PostChanging Excel values to millions
by Lotus » Fri May 15, 2015 12:25 pm

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.

Image
User avatar
DML
Member
Joined in 2008

PostRe: Changing Excel values to millions
by DML » Fri May 15, 2015 12:27 pm

Can we archive this?

Image
User avatar
Karl
Daiakuma
Daiakuma
Joined in 2008
Contact:

PostRe: Changing Excel values to millions
by Karl » Fri May 15, 2015 12:28 pm

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.

User avatar
Lotus
Member
Joined in 2008

PostRe: Changing Excel values to millions
by Lotus » Fri May 15, 2015 12:33 pm

Yes I can, thanks Karl. Pls lock.

Image
User avatar
Albear
Moderator
Joined in 2008

PostRe: Changing Excel values to millions
by Albear » Fri May 15, 2015 12:34 pm

Should it not be

=(A1)*1000000

User avatar
Albear
Moderator
Joined in 2008

PostRe: Changing Excel values to millions
by Albear » Fri May 15, 2015 12:35 pm

Ignore me, I'm bad at reading.

I'm locking this so you can't mock me.

User avatar
Karl
Daiakuma
Daiakuma
Joined in 2008
Contact:

PostRe: Changing Excel values to millions
by Karl » Fri May 15, 2015 12:35 pm

No, that would convert it to being in units of one-millionths-of-a-pound.

User avatar
Karl
Daiakuma
Daiakuma
Joined in 2008
Contact:

PostRe: Changing Excel values to millions
by Karl » Fri May 15, 2015 12:35 pm

Haha, Albear can't do maths, owned. Idiot. Dunce.

User avatar
Dual
Member
Joined in 2008
AKA: Irene Demova

PostRe: Changing Excel values to millions
by Dual » Fri May 15, 2015 12:42 pm

Albear wrote:Should it not be

=(A1)*1000000


Idiot

User avatar
Errkal
Social Sec.
Joined in 2011
Location: Hastings
Contact:

PostRe: Changing Excel values to millions
by Errkal » Fri May 15, 2015 12:51 pm

Image

User avatar
<]:^D
Member
Joined in 2008

PostRe: Changing Excel values to millions
by <]:^D » Fri May 15, 2015 2:34 pm

excellent :D

User avatar
Eighthours
Emeritus
Emeritus
Joined in 2008
Location: Bristol

PostRe: Changing Excel values to millions
by Eighthours » Fri May 15, 2015 2:38 pm

Albear wrote:Should it not be

=(A1be@r)*1000000


FTFY. :D

User avatar
Moggy
"Special"
Joined in 2008

PostRe: Changing Excel values to millions
by Moggy » Fri May 15, 2015 2:40 pm

We need numeracy tests for mods.

Image
User avatar
Albear
Moderator
Joined in 2008

PostRe: Changing Excel values to millions
by Albear » Fri May 15, 2015 3:05 pm

This...must be..what they call....rage

User avatar
Moggy
"Special"
Joined in 2008

PostRe: Changing Excel values to millions
by Moggy » Fri May 15, 2015 3:46 pm

Albear is talking about rape but he is a terrible speller as well.

Image

Return to “Stuff”

Who is online

Users browsing this forum: <]:^D, Blue Eyes, BTB, Bunni, Cuttooth, DrPepperMan, Garth, Google [Bot], Grumpy David, Hime, KK, Lagamorph, lex-man, mark9, OrangeRakoon, Preezy, Rhubarb, Tafdolphin and 45 guests