MrExcel Publishing
Your One Stop for Excel Tips & Solutions

help! need to covert to money

Posted by dee'd ferman on February 12, 2002 6:50 PM

help! i am not that strong on the more advanced features of excel, but because i have figured out other stuff, my boss thinks i can do anything now.
I have a column of numbers in a huge spreadsheet that our accountants screwed up....instead of being 85.00, the amounts were entered as 8500. is there a way to convert all of them to the 85.00, or am i going to have to retype 4000 lines of data?

Posted by Juan Pablo G. on February 12, 2002 7:12 PM

Put 100 in an empty cell. Copy it, select the 4000 cells, go to Paste Special, select "Values" and "Divide", and click Ok.

Juan Pablo G.

Posted by Derek on February 12, 2002 7:15 PM

Re: From toolbar select Edit / Replace (NT)

Posted by dee'd ferman on February 13, 2002 6:22 AM

thank you, thank you, thank you, it worked!!