Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and replace | Excel Discussion (Misc queries) | |||
Search and Replace | Excel Worksheet Functions | |||
Search and Replace | Excel Discussion (Misc queries) | |||
Search and Replace | New Users to Excel | |||
search & replace | Excel Worksheet Functions |