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