Removing/adding decimal points

I guess its probably very simple but half my data has been
entered as 1.11 and the rest as 111.

How do I either get rid or add a decimal point to it all?

Have searched help pretty thougherly and can't see any
thing. The idea of replaceing everything manually thrills
me not all.

To make 1.11 --> 111.

Put 100 in an empty cell.
copy that cell
select your range to be fixed.
Edit|paste special|check multiply.
clean up that helper cell.

(to make 111 --> 1.11, you'd do the same, but choose divide.)

Lou wrote:
>
> I guess its probably very simple but half my data has been
> entered as 1.11 and the rest as 111.
>
> How do I either get rid or add a decimal point to it all?
>
> Have searched help pretty thougherly and can't see any
> thing. The idea of replaceing everything manually thrills
> me not all.

--

Dave Peterson

Highlight the column --> Format Cells --> "Number"
Category: Number. You can choose the number of decimal
places you want. In your case - if the 1.11 is accurate,
then you'll have to manually adjust the 111's - otherwise
they'll turn up to be 111.00.

If you do have to manually go in there - the best way to
do this is sort by that column and then do the copy/paste
method.


>-----Original Message-----
>I guess its probably very simple but half my data has
been
>entered as 1.11 and the rest as 111.
>
>How do I either get rid or add a decimal point to it
all?
>
>Have searched help pretty thougherly and can't see any
>thing. The idea of replaceing everything manually thrills
>me not all.
>.
>