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.