Adding decimal

[pack605]

Hi everyone,

I'm looking to insert a decimal in to be the third character from the right in a sheet with about 5000 different rows all of different lengths. So one row might be 12345 that needs to be 123.45 and the next might be -2345678 that needs to be -23456.78.

Thanks in advance.

 

[Scott Huish]

In a blank cell, put the value 100
Copy this cell.
Select your range to adjust
Right click and click on Paste Special
Under operation, click Divide
Click OK

 

[pack605]

In a blank cell, put the value 100
Copy this cell.
Select your range to adjust
Right click and click on Paste Special
Under operation, click Divide
Click OK

Thanks. Not sure why I didn't even think of that.