How do I move a decimal over two places?

  • Thread starter Thread starter nave
  • Start date Start date
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.
 
I want to make 15.861 become 1586.1

What is the easiest way to do this?
Click to expand...

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.
 
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.
 
Back
Top