Extract fraction as a whole number

[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

 

[Rick Rothstein]

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?

 

[YasserKhalil]

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

 

[Rick Rothstein]

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?

 

[YasserKhalil]

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

 

[Rick Rothstein]

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)

 

[YasserKhalil]

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

 

[YasserKhalil]

There is no way to do that!!!

 

[YasserKhalil]

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

 

[jadhava15]

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.