search and replace

T

Timo

Dear all,

I have a column with mosty numbers (cell format is "general" for all cells
with numbers). Furher I do do a few cells with the following data "6.49E+06"
(cell format Scientific).

I want to replace these strange cells by "649E04".

FYI, if I amend the entire column to "general", cell "6.49E+06" would be
shown as "6490000". How do I search for these cells and amend them to
"649E04"?

Thanks.
 
B

Bernard Liengme

Not by find and replace! The cells all contain numbers and some of them
being displayed in scientific notation.
Did you import these from a text file?
Could you give us a few more example? Do you, for example, have numbers with
E+01 at the end?
 
Top