can't get numbers to round properly
Posted by JMG on February 11, 2002 12:21 PM
i have a list of numbers in a column. some are 3 characters (eg. 324), some 4 (eg. 1795) and some 5 (eg. 10328). What i need to do is convert them to dollars and cents, but reformatting them isn't working. I need it to count from the right and give me 2 decimal places AND round it off. Like 324 would actually be $.03 and 1795 would be $.18 and 10328 would be $1.03. any thoughts are appreciated. . . . .
Posted by Juan Pablo G. on February 11, 2002 12:52 PM
Not sure, but, try this.
If you want to CONVERT all your numbers put 10000 in an empty cell, copy it, select your numbers, go to Edit, Paste Special, and select "Divide" and "Values", click Ok. Now you can format as Currency
If you want to KEEP your values, then, if you have them in A1:A3, put this formula in B1:B3 and format as currency
=A1/10000
Juan Pablo G.
Posted by Ed Acosta on February 11, 2002 12:58 PM
Assuming your numbers is in column A, in Column be type =A1/10000 and copy that all the way down. Then format the column to dollars using 2 decimal places and you are done.
Posted by JMG on February 11, 2002 1:02 PM
Re: THANK YOU!!!!!
I can't believe that several of us have been struggling ALL day over this and the answer was so simple!!! Thanks to both of you - Juan and Ed - SOOO much!!!
