I am copying and pasting race results into a excel spreadsheet and having a problem with prices. For the main part it is fine because I can format the columns so that 9/4 will turn into 2.25 but when it is 9/4F, I am struggling to turn the 9/4 into 2.25 having removed the F using =LEFT(A1,LEN(A1)-1). If I format the cell with this formula in to a number format then it still shows 9/4 not 2.25.
Bookmarks