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
|