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.




319 posts

Ultimate Geek
+1 received by user: 23


# 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.

2537 posts

Uber Geek
+1 received by user: 944

Subscriber

  # 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



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Anyone can broadcast with Kordia Pop Up TV
Posted 13-Jun-2019 10:51


Volvo and Uber present production vehicle ready for self-driving
Posted 13-Jun-2019 10:47


100,000 customers connected to fibre broadband network through Enable
Posted 13-Jun-2019 10:35


5G uptake even faster than expected
Posted 12-Jun-2019 10:01


Xbox showcases 60 anticipated games
Posted 10-Jun-2019 20:24


Trend Micro Turns Public Hotspots into Secure Networks with WiFi Protection for Mobile Devices
Posted 5-Jun-2019 13:24


Bold UK spinoff for beauty software company Flossie
Posted 2-Jun-2019 14:10


Amazon Introduces Echo Show 5
Posted 1-Jun-2019 15:32


Epson launches new 4K Pro-UHD projector technology
Posted 1-Jun-2019 15:26


Lenovo and Qualcomm unveil first 5G PC called Project Limitless
Posted 28-May-2019 20:23


Intel introduces new 10th Gen Intel Core Processors and Project Athena
Posted 28-May-2019 19:28


Orcon first to trial residential 10Gbps broadband
Posted 28-May-2019 11:20


Video game market in New Zealand passes half billion dollar mark
Posted 24-May-2019 16:15


WLG-X festival to celebrate creativity and innovation
Posted 22-May-2019 17:53


HPE to acquire supercomputing leader Cray
Posted 20-May-2019 11:07



Geekzone Live »

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


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



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.

Alternatively, you can receive a daily email with Geekzone updates.