Sign in with
Sign up | Sign in
Your question

Converting numbers to currency value issue MS O 2010

Last response: in Applications
Share
January 3, 2013 2:23:47 PM

Hey there everyone,

So.. What I'm trying to figure out is how to take a bunch of numbers in excel 2010 and convert them to a currency value. For example.... Turning 2000 into $20.00.

If I go to format cell, Currency/number and add the decimals I end up getting $2,000.00. I'm assuming what I need to be looking towards is > Format Cell > Custom and then make my own but I'm at a loss as to where to go from there. (really want to avoid manually changing each number as there's thousands) Anyone have any idea if this is possible? Been searching for a while and can't find anything useful.

Thanks in advance!
January 3, 2013 2:56:11 PM

So I think i may have figured a work around out.
Using the cell next to it i just used the formula IE: =B1/100 (copy paste / drag down) to change it to 20 instead of 2000 and then convert to a currency which puts the decimals into the right place :D .

Sorry for the stupid question lol.
m
0
l
!