How do I move a decimal over two places?

[nave]

I want to make 15.861 become 1586.1

What is the easiest way to do this?

Thank you

 

[Norman Harker]

Hi Nave!

Insert a helper column
=A1*100
Select the revised data
Copy > Edit > Paste Special > Values > OK

Now decide whether you want to keep or delete the original data.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Hank Scorpio]

I want to make 15.861 become 1586.1

What is the easiest way to do this?

In addition to Norman's answer, you can also do the following:
- Type 100 in a blank cell;
- Copy it;
- Select the cell(s) that you want to change;
- Go to the Edit menu (or right click), choose Paste Special ->
Operation, then choose Multiply.

 

[nave]

Thank you both. That was easy enough, I feel stupid for asking now

thanks agai

 

[Norman Harker]

Hi Nave!

Thanks for thanks.

Re: "That was easy enough, I feel stupid for asking now"

No! "Stupid" is not asking when help is available.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.