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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Current row[/TD]
[TD]New Row[/TD]
[/TR]
[TR]
[TD]12758190[/TD]
[TD]127581.90[/TD]
[/TR]
</tbody>[/TABLE]

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!