Hi

Enter 1 in an unused cell an copy the cell, then select the cells to turn
into numbers, right click the selection PasteSpecial : Multiply.

Format the cells as Number, using the desired format.

Regards,
Per

"Dani B" <Dani skrev i meddelelsen
...
Hi all,

I have a bunch of data with a price as TEXT and I know there is a way of
eliminating the 0's but I cant remeber teh formula.

An example would be:
Data as is now want it to be
00000000665000 which is equal to 66.500

00000000665000=66.500

Anyone knows how to eliminate the zeros and put the period to a place I
want
to be.

Thanks