Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting decimal fractions of minutes to seconds | Excel Worksheet Functions | |||
fractions to decimal | Excel Programming | |||
Convert decimal to fractions | Excel Worksheet Functions | |||
converting fractions to decimal | Excel Discussion (Misc queries) | |||
How do I convert decimal inches to fractions in excel | Excel Discussion (Misc queries) |