On Thu, 17 Nov 2005 13:06:06 -0800, rjtees
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