Delete first two digits in column

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

[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

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

[Duke Carey]

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.

[rjtees]

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.

[Ron Rosenfeld]

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