importing numeric data

  • Thread starter Thread starter slapshot26
  • Start date Start date
S

slapshot26

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?
 
Can you open the other program output in Notepad and tell us what you see?
best wishes
 
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
 

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

How do I stop Excel 2007 from using scientific notation? 2
CSV text data altered on file open 4
Rounds the large numeric value 2
Import large number string 1
Access stripping decimal places in query 1
Hex numbers displayed in scientific notation when importing text f 2
automatic formatting on import of .DIF files 3
text converted to scientific notations 3

Back
Top