Delete first two digits in column

[Guest]

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.

 

[Guest]

use an adjacent column and enter a formula such as

WORK ON A COPY OF YOUR DATA

=100*(a2-int(a2))

Copy it down for all the target values. When done, copy all these new
formulas, select the original data, and use Edit->Paste Special->Values.
Then delete your formulas

 

[Guest]

Ignore that last answer -

use this formula instead

=RIGHT(A2,LEN(A2)-SEARCH(".",A2))*1

 

[Ron Rosenfeld]

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

 

[Guest]

Thank you so much, worked perfectly.

use an adjacent column and enter a formula such as

WORK ON A COPY OF YOUR DATA

=100*(a2-int(a2))

Copy it down for all the target values. When done, copy all these new
formulas, select the original data, and use Edit->Paste Special->Values.
Then delete your formulas