Delete first two digits in column
 

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.

Delete first two digits in column
 

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

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

Delete first two digits in column
 

Ignore that last answer -

use this formula instead

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

"Duke Carey" wrote:

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

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

Delete first two digits in column
 

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

Delete first two digits in column
 

Thank you so much, worked perfectly.

"Duke Carey" wrote:

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

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