Hi guys, first time poster. I have a problem entering 16 digit data. The last digit always appear to be zero. I can't edit it. I tried format the cell seems nothin wrong with it. Any help is greatly appreciated.
Hi guys, first time poster. I have a problem entering 16 digit data. The last digit always appear to be zero. I can't edit it. I tried format the cell seems nothin wrong with it. Any help is greatly appreciated.
Excel's number precision limit is 15 digits...
If you have to see that char, you will have to convert your cell format to text...
add an apostrophe in front of the number you are typing.
e.g. '1234567890123456
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Or format cell as text does the same thing
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thanks a bunch you guys!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks