| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing numeric data
Every time I open a file with numeric data (in scientific notation) from
another program, the decimal place gets moved. Ex: 1.04465E-2 (or 0.014465) becomes 1.04465E2 (or 104.465) Is there any way to stop the changing of the sign? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
importing numeric data
Can you open the other program output in Notepad and tell us what you see?
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "slapshot26" wrote in message ... Every time I open a file with numeric data (in scientific notation) from another program, the decimal place gets moved. Ex: 1.04465E-2 (or 0.014465) becomes 1.04465E2 (or 104.465) Is there any way to stop the changing of the sign? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
importing numeric data
In the opened the problematic WB have a look at 'Tools' 'Options' 'Edit'
tab 'Fixed Decimal point'. If it is checked - un-check it. Micky "slapshot26" wrote: Every time I open a file with numeric data (in scientific notation) from another program, the decimal place gets moved. Ex: 1.04465E-2 (or 0.014465) becomes 1.04465E2 (or 104.465) Is there any way to stop the changing of the sign? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
| Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Linear Mode
