G
Guest
A couple of problems:
1) Numerical data that is imported to Access from Excel produces a
transposition of formatting - if text in Excel, it becomes number in Access
and vice versa. What could be causing this?
2) In Excel I have converted a cell containing a number in text format to
number format but this does not 'take effect' (i.e. cell contents default to
the right as is normal for numbers) until I hit F2 and press return (the
equivalent of entering the number). This only occurs occasionally and I
cannot see any pattern.
1) Numerical data that is imported to Access from Excel produces a
transposition of formatting - if text in Excel, it becomes number in Access
and vice versa. What could be causing this?
2) In Excel I have converted a cell containing a number in text format to
number format but this does not 'take effect' (i.e. cell contents default to
the right as is normal for numbers) until I hit F2 and press return (the
equivalent of entering the number). This only occurs occasionally and I
cannot see any pattern.