Preformat the cell as text
or start with a leading apostrophe '123456789123456789

But then the value will be text--not a number.

gvn wrote:

I am unable to enter 123456789123456789 as this displays as
123456789123456000 which is incorrect. any thoughts

--

Dave Peterson