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

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

To convert to numbers -
Enter 1 anywhere on the sheet
Copy the cell where you entered 1
Select your column of numbers as TEXT
Choose Edit-Paste Special and then check MULTIPLY and press OK

Or

Select the col
Choose Text to Columns and choose data type as Numbers...

For decimal point divide by the appropriate number (10, 100, 1000...)

"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

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