Thanks:  0
Likes:  0

Thread: Extract fraction as a whole number

1. Extract fraction as a whole number

Hello
I want to extract just the fraction as a whole numer even if the fraction has a zero at its end
Example
16.1500 - 12.140 - 10.01 - 60.0060

The results should be

1500 - 140 - 01 - 0060

2. Re: Extract fraction as a whole number

Originally Posted by YasserKhalil
Hello
I want to extract just the fraction as a whole numer even if the fraction has a zero at its end
Example
16.1500 - 12.140 - 10.01 - 60.0060

The results should be

1500 - 140 - 01 - 0060
Is your example the text in one single cell or are those dashes supposed to represent column breaks between different cells? If the latter, what is your cells formatted as in order to retain the trailing zeroes?

3. Re: Extract fraction as a whole number

These values are numeric in range("A1:A4") not a text but I want to extract the whole fraction

4. Re: Extract fraction as a whole number

Originally Posted by YasserKhalil
These values are numeric in range("A1:A4") not a text but I want to extract the whole fraction
If they are not text, then how are the trailing zeroes being shown?

5. Re: Extract fraction as a whole number

Originally Posted by Rick Rothstein
If they are not text, then how are the trailing zeroes being shown?
Different formats sir
I know it is weird but these values formatted diffenetly not the same

6. Re: Extract fraction as a whole number

Originally Posted by YasserKhalil
Different formats sir
I know it is weird but these values formatted diffenetly not the same
I don't get it... if they are not text, then they are numbers and numbers do not retain trailing zeroes after a decimal point. The only way to get a number to display trailing zeroes is to format the cell, but the value in the cell would still be a number without a trailing zero... besides cell formatting cannot be being used because the number of digits after the decimal point is not constant. So I don't get it. You might try this formula, but I do not hold out hope that trailing zeroes will be preserved...

=MID(A1,FIND(".",A1)+1,99)

7. Re: Extract fraction as a whole number

Is there a function that can split the number to whole number and the fraction as a whole numer..
I hope to find a way to solve this problem...
The problem now is the trailing zeroes !!
Simply these are numbers but I want to treat them as text and get my results

8. Re: Extract fraction as a whole number

There is no way to do that!!!

9. Re: Extract fraction as a whole number

Please there must be a way to get the fraction as it is!!

10. Re: Extract fraction as a whole number

Originally Posted by YasserKhalil
Please there must be a way to get the fraction as it is!!

Hi,

try below formula,

=RIGHT(J3,LEN(J3)-FIND(".",J3))

regards,
Amitkumar J.

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•