Converting numbers to currency value issue MS O 2010

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!
1 answer Last reply
More about converting numbers currency issue 2010
  1. 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.
Ask a new question

Read More

Office Excel 2010 Format Apps