| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format problem
We import results into Excel 2003 from third party software. One column is
populated with identifiers such as 3B2, 3C2, 3E4 etc. Any identifiers that have an "E" in them convert to Scientific Notation (3.00E +04) inappropriately. I click on the column and format the number type for the column to be "General", which then converts the Scientific Notation to a number (e.g. 30000). We correct the number to 3E4 but it then reverts back to Scientific Notation. When we check the format of the cell it has switched from General back to Scientific. How can we avoid this and get the spread sheet to accept the format 3E4 or 4E1 or whatever it should be? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
| Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
| How to refer to a cell format code? | Excel Discussion (Misc queries) | |||
| Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
| Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
Threaded Mode
