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