Converting numbers to currency value issue MS O 2010

unoriginal1

Honorable
Apr 11, 2012
155
0
10,660
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!
 

unoriginal1

Honorable
Apr 11, 2012
155
0
10,660
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.