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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

large numbers as text replaced with scientific notation 2
Stop XL from changing format? 1
Numbers change in cell even when formatted as text 4
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Remove date format? 3
Replace numbers with time 3
Conditional formatting in Excel 2010 2

Back
Top