Delete first two digits in column

R

rjtees

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.
 
D

Duke Carey

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
 
D

Duke Carey

Ignore that last answer -

use this formula instead

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

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.
Click to expand...

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
 
R

rjtees

Thank you so much, worked perfectly.

Duke Carey said:
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
Click to expand...
 
Top