search and replace

  • Thread starter Thread starter Timo
  • Start date Start date
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.
 
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?
 
Back
Top