View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default 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?