Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page In Excel, formatted scientific notation field is displaying 0 for last digit
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-04-2019, 04:21 PM
p45cal's Avatar
p45cal p45cal 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 2019
Expert
  
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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
 

« Previous Thread | Next Thread »


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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 PM.

Contact Us - Privacy Statement - Top

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