Is your entry in the cell A1*2 or =A1*2?


wrote in message
...
: 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.
: