search and replace
 

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.

search and replace
 

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?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Timo" wrote in message
...
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.