I need to take a column of numbers and simply remove the decimal point. I
need to have zero's or a number to hold the space of the ones and tens place.

I have a column of numbers where I have changed the numbers to put zero's as
holders in the tens and/or ones places as needed to keep data integrity.
But when I run a replace 'the decimal point with nothing', Access just hangs
up. Is this a known issue? Is there a work around.

started with Now Have Want
12.3 12.30
1200
14.45 14.45
1445
..99 .99
99
1.00 1.00
100

Thanks

--
Gina

Gina:

As far as I can see from your examples you just need to multiply the
original number by 100. I'm assuming the 'want value in the first row should
be 1230.

Ken Sheridan
Stafford, England

"Gina" wrote:

> I need to take a column of numbers and simply remove the decimal point. I
> need to have zero's or a number to hold the space of the ones and tens place.
>
> I have a column of numbers where I have changed the numbers to put zero's as
> holders in the tens and/or ones places as needed to keep data integrity.
> But when I run a replace 'the decimal point with nothing', Access just hangs
> up. Is this a known issue? Is there a work around.
>
> started with Now Have Want
> 12.3 12.30 1200
> 14.45 14.45 1445
> .99 .99 99
> 1.00 1.00 100
>
> Thanks
>
> --
> Gina

You are right about the 1230.

Sometimes the answer is just too simple. Thanks. A few modifications and
it Works perfectly.

Again, Thanks,
--
Gina


"Ken Sheridan" wrote:

> Gina:
>
> As far as I can see from your examples you just need to multiply the
> original number by 100. I'm assuming the 'want value in the first row should
> be 1230.
>
> Ken Sheridan
> Stafford, England
>
> "Gina" wrote:
>
> > I need to take a column of numbers and simply remove the decimal point. I
> > need to have zero's or a number to hold the space of the ones and tens place.
> >
> > I have a column of numbers where I have changed the numbers to put zero's as
> > holders in the tens and/or ones places as needed to keep data integrity.
> > But when I run a replace 'the decimal point with nothing', Access just hangs
> > up. Is this a known issue? Is there a work around.
> >
> > started with Now Have Want
> > 12.3 12.30 1200
> > 14.45 14.45 1445
> > .99 .99 99
> > 1.00 1.00 100
> >
> > Thanks
> >
> > --
> > Gina
>