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