View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
evoxfan evoxfan is offline
external usenet poster
 
Posts: 65
Default Add decimal to number

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?