Is there a formula to add decimals to values in a new row?

[trojman]

I have a data set that does not have any decimals. I turned on fixed decimal and tried to copy the data in a new column, but that didn't work. Instead of having to re-type 30K entries, is there a way to copy the data with no decimals to a new row with decimals?

For example:

Current row	New Row
12758190	127581.90

<tbody>
</tbody>

Thanks in advance!

 

[Joe4]

Welcome to the Board!

If you value is in cell A2, then just create a formula to divide it by 100, i.e.
=A2/100

You could even do it in the same column (overwriting the original values) using Copy -> Paste Special -> Divide

 

[trojman]

That was way too easy!! Thanks!

 

[Joe4]

You are welcome!