View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Changing 123456 to $1234.56

Put 100 in an empty cell
Edit copy that cell

Select the range to adjust
edit|paste special|check Divide

And then go back and clean up that cell with 100 in it.

And format that range the way you like.

YoYo2 wrote:

I have a large column of numbers that needs the decimal inserted. Please help


--

Dave Peterson