Quote:
Originally Posted by Jo Freeman
to be honest, some of the discussion was way too complicated for me to understand!
|
And not at all relevant to your problem.
The take away is....
1. You are right: format the cell as Text first, then enter the long "number" as text.
2. Do not try to use the long "number" in an arithmetic expression; you will lose accuracy. I don't think you would: I presume the long "number" is actually an ID.