How can a 18 digit number be entered with out being transposed or.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using excell I need to paste numbers in a cell. When I do the number
becomes transposed or has decimals. When I look at it in Access the number
is distorted. What can I do to prevent this.
 
On Wed, 24 May 2006 17:32:02 -0700, 18 digits <18
When using excell I need to paste numbers in a cell. When I do the number
becomes transposed or has decimals. When I look at it in Access the number
is distorted. What can I do to prevent this.
Click to expand...

Unless you are doing arithmatic with these numbers (I'm guessing that
they are *identifiers* rather than values for calculation), use a Text
field.

'41246691342983

in Excel (with the quote) will be stored as a text string - and you
can handle up to 255 digits with no distortion or problems.

John W. Vinson[MVP]
 
Back
Top