Hi all.
I have copied and pasted sports statistics from a website that tracks number of made basketball shots versus number of total shots. For example 5-10 is supposed to indicate the player made five of ten shots or 50%.
So I can go ahead and set these cells to a format of number or percentage, but when I attempt to convert the minus sign to a forward slash via find and replace, Excel attempts to calculate the value, but somehow totally screws up! So, in our 5/10 example, Excel (2007) turns this value into 3994300% or 39943.00.
Note that in Openoffice Calc, when I select the value of the cell, each value is proceeded by an apostrophe. When I remove the apostrophe, Calc does the same thing. If I enter "=5/10" in either program, the value is calculated as expected.
Any ideas?
Thanks in advanced,
Dan
Bookmarks