 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Exacting the fractional
How do you extract the fraction out of column A and put the fractiona in column B... example A B 25.375 .375 7.975 .975 7.25 .25 7.25 .25 7.25 .25 8 =mod(a1,1) or =a1-int(a1) Do you get what you want with negative numbers? > How do you extract the fraction out of column A and put the fractional > in column B... [quoted text clipped - 15 lines] > TaGY2K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1861 > View this thread: http://www.excelforum.com/showthread.php?threadid=565313  SignatureDave Peterson thanks work. >How do you extract the fraction out of column A and put the fractional >in column B... [quoted text clipped - 9 lines] >7.25 .25 >87 =MOD(A1,1) or =A1-INT(A1) --ron
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.