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?