Enter 100 in an unused cell.

Copy that cell.

Select the range to change and EditPaste SpecialDivideOKEsc

Delete the 100 from the cell.


Gord Dibben MS Excel MVP


On Fri, 12 Sep 2008 14:26:02 -0700, Kolsballs
wrote:

Hi

I don't know if this is possible but can you turn a four digit number e.g
1234 into 12.34 in excel. I have tried many things but nothing seems to work.

I have over 10,000 cells to change into this format and it would take to
long for me to change them manually. The file is originally a csv file as I
have been trying to upload this file to an epos tile but when the price shows
up on the till it comes up in the thousands instead of the pounds and pence
amount.

Many Thanks