On Thu, 17 Nov 2005 13:06:06 -0800, rjtees <rjtees@discussions.microsoft.com>
wrote:

>I need to delete 1 digit and then the decimal point, so that the # in the
>cell is only what was after the decimal point (ie, 1.1100 to 1100). I'v got
>about 2000 rows and don't have time to delete them manually.

Excel stores 1.1100 as 1.11.

If you always want to see as a positive integer the four places after the
decimal point, then use the formula:

=TRUNC(MOD(A1,1)*10^4)

If you want something else, you will need to be more specific.



--ron