Microsoft Office Forums In Excel, formatted scientific notation field is displaying 0 for last digit

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-04-2019, 11:26 AM
Burt Burt is offline In Excel, formatted scientific notation field is displaying 0 for last digit Windows 10 In Excel, formatted scientific notation field is displaying 0 for last digit Office 2016
Novice
In Excel, formatted scientific notation field is displaying 0 for last digit
 
Join Date: Apr 2019
Posts: 17
Burt is on a distinguished road
Default In Excel, formatted scientific notation field is displaying 0 for last digit

I have exported Salesforce data into a Excel (please see attached). The Credit Card No. field exported in scientific notation. When I click on any of those cells, the last digit has been changed to 0, or if I convert that column to a different format the last digit of each credit card numbers is 0. However, when I import the data back into Salesforce, the last digit imports correctly (not 0).... so I know the correct data must be in the Excel file, I just don't know how to see it.



How can I view the Credit Card No. column without the last digit displaying 0 for all the rows?


Thanks,
Burt
Attached Files
File Type: xlsx Salesforce Export.xlsx (9.9 KB, 2 views)
Reply With Quote
  #2  
Old 12-04-2019, 04:21 PM
p45cal p45cal is online now In Excel, formatted scientific notation field is displaying 0 for last digit Windows 10 In Excel, formatted scientific notation field is displaying 0 for last digit Office 2019
Expert
 
Join Date: Apr 2014
Posts: 314
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

Credit card numbers are never used to do maths with, they're just unique identifiers.
Import them as text, then you won't get rounding errors.
How are you exporting/importing this stuff into Excel?
Reply With Quote
  #3  
Old 12-04-2019, 04:46 PM
Burt Burt is offline In Excel, formatted scientific notation field is displaying 0 for last digit Windows 10 In Excel, formatted scientific notation field is displaying 0 for last digit Office 2016
Novice
In Excel, formatted scientific notation field is displaying 0 for last digit
 
Join Date: Apr 2019
Posts: 17
Burt is on a distinguished road
Default

Hi p45cal,

Thank you for your reply.

I am using a tool called dataloader.io (used for Salesforce data). I'm not actually having a problem with the exporting/importing. I can export and import it back in and the data is fine, so I know the data is there. But when I try to view in Excel I cannot see the 16th digit. I tried converting the field to text, but it shows a 0. Like I said, when I import it the last digit is correct (not 0) so I would think there should be a way to format it in Excel so I can view the last digit.


Thanks,
Burt
Reply With Quote
  #4  
Old 12-04-2019, 04:55 PM
p45cal p45cal is online now In Excel, formatted scientific notation field is displaying 0 for last digit Windows 10 In Excel, formatted scientific notation field is displaying 0 for last digit Office 2019
Expert
 
Join Date: Apr 2014
Posts: 314
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

Take a look at Exporting a text field but it is treating it as a number in scientific notation – dataloader.io and the link in the reply containing 16 replies - you might get some ideas from there.
Reply With Quote
  #5  
Old 12-04-2019, 05:04 PM
Burt Burt is offline In Excel, formatted scientific notation field is displaying 0 for last digit Windows 10 In Excel, formatted scientific notation field is displaying 0 for last digit Office 2016
Novice
In Excel, formatted scientific notation field is displaying 0 for last digit
 
Join Date: Apr 2019
Posts: 17
Burt is on a distinguished road
Default

Great....I will have a look. Thanks again!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency Field - Displaying Incorrect Value when Formatted DarrenE Mail Merge 11 03-20-2019 01:40 PM
In Excel, formatted scientific notation field is displaying 0 for last digit number field coming over with missed digit sherrin Mail Merge 1 04-20-2016 06:06 PM
In Excel, formatted scientific notation field is displaying 0 for last digit Change houre notation when wrong notation is entered dlquinte Excel 1 04-12-2016 03:35 AM
Regex/wildcard search for dates with 2-digit and 4-digit years Marrick13 Word VBA 2 01-29-2016 07:04 AM
In Excel, formatted scientific notation field is displaying 0 for last digit A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 laucn Excel Programming 14 05-17-2015 12:12 PM


All times are GMT -7. The time now is 04:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft