=A1/100 and format the cell to display 3 digits
--
Gary''s Student - gsnu200806


"evoxfan" wrote:

I have a column of 5 digit numbers like this:
15055
15060
15071

I would like add a decimal after 3 digits and 0 to the end to show:
150.550
150.600
150.710

What would be the best way to accomplish this?