Removing/adding decimal points

L

Lou

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

Dave Peterson

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.)
 
G

Guest

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