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.

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?

User avatar
That
Dr. Nyaaa~!
Dr. Nyaaa~!
Joined in 2008

PostRe: Changing Excel values to millions
by That » 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.

Image
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.

Albert
Moderator
Joined in 2008

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

Should it not be

=(A1)*1000000

Albert
Moderator
Joined in 2008

PostRe: Changing Excel values to millions
by Albert » 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
That
Dr. Nyaaa~!
Dr. Nyaaa~!
Joined in 2008

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

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

Image
User avatar
That
Dr. Nyaaa~!
Dr. Nyaaa~!
Joined in 2008

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

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

Image
User avatar
Dual
Member
Joined in 2008

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
Member
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
AKA: Moggy

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

We need numeracy tests for mods.

Albert
Moderator
Joined in 2008

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

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

User avatar
Moggy
"Special"
Joined in 2008
AKA: Moggy

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.


Return to “Stuff”

Who is online

Users browsing this forum: Garth, Gideon, Grumpy David, Rawrgna, Trelliz, Vermilion and 381 guests