Excel: 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


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of October 16, 2014.


For more resources for Microsoft Excel