Separating the Parts of a Mixed Number?

If you mean the whole number and the decimal, then

=MOD(A1,1) is the decimal
=INT(A1) is the whole number.

Super, that solves one of the two problems. I can now separate the whole number from the decimal!!!!! thank you.

Now I have a decimal that I can turn into a fraction. How do I separate the numerator from the denominator????

Thanks,
Tom

Hi Tom

I'm not sure I understand exactly what you want.

1 - If it's to display the number as a mixed number, you can do it directly using a custom format, like

# #/#
# #/##
# #/###

where you define the precision by setting the maximum number of digits in the denominator.

For ex., for the sqare root of 2 you get 1 2/5, 1 29/70, 1 408/985.


2 - If you want to extract just the denominator to another cell you can use the TEXT() function and extract the number after the "/"

For ex., for a denominator with a maximum of 3 digits:

=IF(ISERROR(FIND("/",TEXT(A1,"# #/###"))),"",--MID(TEXT(A1,"#/###"),1+FIND("/",TEXT(A1,"#/###")),3))

HTH
lecxe

There is a method call continued fractions to obtain successively better rational approximations to any given number.

For pi, for example, 3, 22/7, 333/106, 355/113, 103993/33102, ...

For e, 3, 8/3, 11/4, 19/7, 87/32, 106/39, 193/71, ...

Why do want to do this?

Thanks,

Getting closer. Here is what I need now. I have a cell in which is generated a decimal number such as 7.719. I can format that to be a mixed number with a denominator of 256. I will always have that denominator, or 512. So now the cell shows 7 184/256. How can I extract the 184 into another cell?

Thanks,
Tom

WOW SHG! That is it! My hat is off to you.

Thanks,
Tom