Hi,

2 ways. With your number in A1 try this

=A1*1

or

Put a 1 in a cell and copy it. Selevt thiese numbers and then

Edit|Paste Special - Multiply - OK

Delete the 1

Mike

"Dani B" wrote:

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