View Single Post
  #1  
Old September 16th, 2004, 01:31 PM
external usenet poster
 
Posts: n/a
Default excel workbook acting weird

I have an excel workbook that I converted from text. When
I create formula in a cell (A1*2) it just displays the
formula and not the result. I checked the options and it
is not set to display formula.

Also, when I transfer this sheet to access, I am storing
the values in field A to a text field. THe value in A are
S123, 87922035, etc. Some of the numbers get saved as
5.7273e+006 even thought they appear as numbers in Excel.

Help please.