Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


KillerHulk

348 posts

Ultimate Geek
+1 received by user: 24


#208571 17-Feb-2017 12:26
Send private message

Hi,

 

When u punch in long numbers into excel cell, it changes it to zero or a formula thing.

 

For Example:

 

my original number is 881654014321, but excel changes it to either "8.81654E+11" or "881654000000" when i save it.

 

Also when i change back the cell format for "8.81654E+11" to "number", it changes to "881654000000" (which is not even my original number)

 

The problem is , i have to do CVS uploads and they show as error because "part number no found".

 

 

 

Any permanent fix for this ?

 

Thanks in advance..





I Eat Dumbbells for Breakfast


View this topic in a long page with up to 500 replies per page Create new topic

This is a filtered page: currently showing replies marked as answers. Click here to see full discussion.

Inphinity
2780 posts

Uber Geek
+1 received by user: 1184


  #1721822 17-Feb-2017 13:18
Send private message

Microsoft knowledge base article about Excel truncating number values to 15 significant figures, leading remaining places as 0. From your example, though, it looks like your number is only 12 digits to begin with. What version of Excel are you using? Both the prior suggestions here - Number with 0 decimal places, or Text with a leading ' - display your example value correctly for me in both Excel 2013 and Excel 2016, as does setting it to Custom with a Type of 0.

 

 


View this topic in a long page with up to 500 replies per page Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.