problem with fractions to decimal
I'm creating a spreadsheet that tracks and records line moves in Vegas.
when I copy and paste the data into a sheet, the point spread (+3½) and money line (-105) are both entered into the same cell. like +3½ -105 to separated the two I using =Left(B2,3) to extract +3½ into cell D2 but now I can't get add or subtract anything to that number because the ½ is there and the sheet recognizes it as a text, not a number. I tried to format it as a fraction with #?/? didn't work Tried to use find ( and replace, that didn't work. Here is the sheet. feel free to edit it if you have a solution https://docs.google.com/spreadsheets...it?usp=sharing thanks. |
problem with fractions to decimal
Hi,
Am Sun, 28 Sep 2014 09:12:45 -0700 (PDT) schrieb : to separated the two I using =Left(B2,3) to extract +3½ into cell D2 but now I can't get add or subtract anything to that number because the ½ is there and the sheet recognizes it as a text, not a number. 1/2 is one character. Try: =IF(RIGHT(B2,1)="½",--(LEFT(B2,2))+(LEFT(B2,1)&1/2),B2*1) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
problem with fractions to decimal
Hi again,
Am Sun, 28 Sep 2014 09:12:45 -0700 (PDT) schrieb : to separated the two I using =Left(B2,3) to extract +3½ into cell D2 but now I can't get add or subtract anything to that number because the ½ is there and the sheet recognizes it as a text, not a number. 1/2 is char(189) So you can try: =IF(RIGHT(B2,1)=CHAR(189),--(LEFT(B2,2))+(LEFT(B2,1)&1/2),B2*1) Or look he https://onedrive.live.com/?cid=9378A...121822A3%21326 for workbook "5Dimes Sportsbook, Casino, Poker, Racebook and Lotto" Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com