Thread
:
problem with fractions to decimal
View Single Post
#
3
Posted to microsoft.public.excel.misc
Claus Busch
external usenet poster
Posts: 3,872
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 With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch