Most valuable professional
  • Hot Topics

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel