I am new to this forum and I really hope someone can help.
I have a spreadsheet with a colum that has tons of fractions that look
like this(22/8, 45/6, 313/9, etc.) you get the point. What I am asked
to do is go through this colum and change each one to a whole number
(ex. 22/8 would be changed to 23, 45/6 is changed to 46). Basically
what I want to do to save so much time(and I'm not sure if this is
possible) is to make a function that will find the fraction, for
instance 22/8, multiply it by the bottome number (8) and then add 1. I
really hope someone can help. If i'm unclear, let me know and I will
try to explain better. Thanks sooo much in advance.


--
wytedragn
------------------------------------------------------------------------
wytedragn's Profile: http://www.excelforum.com/member.php...o&userid=35918
View this thread: http://www.excelforum.com/showthread...hreadid=557105