Free Online Scan - Free Online Scan
last updated on: 11/10/16 08:44AM
   Troubleshoot Enter 18 digit number Chinese ID card into Excel [11/10/16 08:44AM]   
Rate this post  

Enter 18 digit number (Chinese ID card) into Excel

I have a Chinese ID card number which looks something like this:  256589199925059999.
 They will always be 18 digits (sometimes with an X as the last number).
Now put that into an Excel field, chose, text, custom ###, an 'apostrophe at the front, or all manner of formats and the number is messed up.
from this: 256589199925059999
to this:     256589199925059000
It doesn't seem to matter on the number, but the last few digits are recalculated.
 Bizarrely I can't find anyone complaining about this problem (maybe in Chinese language there is a solution).
 One work around is to add spaces to the number, but that isn't
the best solution.
Why does it happen, and how can I maintain the correct formatting?
Thanks!
Andy

Anwsers to the Problem Enter 18 digit number (Chinese ID card) into Excel

Download Error Fixer (Free)

Hi,
Try putting the single apostrophe in the cell before typing/pasting the value in.
Regards

Because of this Enter 18 digit number (Chinese ID card) into Excel error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error Enter 18 digit number (Chinese ID card) into Excel can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve Enter 18 digit number (Chinese ID card) into Excel error or repair the corrupted and damaged Windows files, you will need a Enter 18 digit number (Chinese ID card) into Excel error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

  1. Start the computer and log in as administrator
  2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
  3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
  4. On the new confirmation window that appears, click Next
  5. Restart your computer after the restoration has been completed

Another Safe way to Fix the Problem: Enter 18 digit number (Chinese ID card) into Excel:

How to Fix Enter 18 digit number (Chinese ID card) into Excel with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.5.7.0.92,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03,Data Export From Quickbooks To Excel,Date Format In Formula Bar And In The Cell Is Not The Same,Deleted The Snipping Tool,Desktop - Open Program Issues,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: Enabling CD-Rom Drive on Windows 7,Fast Solution to Error: Erradic window shifting from excel to desktop while working in excel.,Troubleshoot Embedding the Password into the Microsoft Query Data Source Error,How to Fix Error - Enable outbound FTP from 2nd nic card?,Troubleshooting erreur 500 comment corriger merci,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?,Does Log Me In Ignition for my Android with Windows 7 Home Premium?,Download failure for my Blackberry and the process stops during the install,Display settings keep changing when I come back from sleep mode,Downloaded files are not saved



   Trackbacks

      TRACKBACK URL: http://freeonlinescan.blogghy.com/trackback/1056364

   Comments

   Post a comment
Name:


Email:


4 + 3 = ?

Please write above the sum of these two integers

Title:


Comments:





About the author

Contact the author
Categories

Latest blog posts
Troubleshoot Enter 18 digit number Chinese ID card into Excel
[11/10/16 08:44AM]
Troubleshoot Disabling Metro Start Screen Reinstalling Start Menu Windows 8 Error
[27/09/16 05:10AM]
Troubleshooting cannot use links in e m i have vista Error
[14/09/16 04:42AM]
How to Fix Problem Press ESC Key for Startup Menu
[13/07/16 05:35AM]
Tech Support Not able to turn on Windows Media Player in Windows Features
[04/07/16 11:05AM]
Top views posts
Troubleshoot Enter 18 digit number Chinese ID card into Excel
[11/10/16 08:44AM] Daily Views 1
Anwsered My labels are printing out of the area my name and address is on one label and town on the next label I can not get page to print full page of the same label
[17/05/16 04:19AM] Daily Views 0
How Can I Fix my skype crashes as soon as I click on some one I have rebooted and also uninstalled and reinstalled several times
[31/05/16 04:01AM] Daily Views 0
Troubleshoot No audio output device is installed and resolution is smaller than it should be Error
[14/06/16 04:54AM] Daily Views 0
How to Fix Num lock on at log on
[04/07/16 11:05AM] Daily Views 0
Photo Albums








Powered by Blogghy

Page generated in 0.2107 seconds.