How to eliminate 0's

[Dani B]

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

 

[Mike H]

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

 

[Sheeloo]

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...)

 

[Per Jessen]

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