You are reading a single comment by @chez_jay and its replies.
Click here to read the full conversation.
-
15 digit+ numbers aren't stored as integers by default in Excel, so the exact value is lost.
If you don't need to do any maths on them in Excel, you should be fine storing them as text, which will preserve the exact value.
[Edit: it's apparently possible to use DOUBLE ints, but above is probably the simplest solution for the given problem]
chez_jay
They are going to be stored in a sheet as information. The "numbers" are used in building an sql query later. But someone needs to say "yes" "no" to the stuff going in the query.
Make sense?