Excel automatically rounds off any number which is more than 15 digits.
how do i prevent them.
You can't prevent this, as Excel has a 15 digit limitation. It cannot be bypassed. Digits longer than 15 characters need to be entered as text, and cannot be calculated.
Type "Excel specifications and limits" into Excel HELP for further information.
HTH
Bruce
The older I get, the better I used to be.
Minneapolis, MN USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks