In an empty cell enter .01. Copy that cell, select all the values you want
to change, use EditPaste SpecialMultiply



"Beth" wrote:

Hello everyone,

I have got a list of values e.g. 61025, 68653

I want these to be shown as 610.25, 686.53.

Is there a function that I can use to achieve this?

Regards,
Beth