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?
Anwsers to the Problem Enter 18 digit number (Chinese ID card) into Excel
Download Error Fixer (Free)
Try putting the single apostrophe in the cell before typing/pasting the value in.
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:
- Start the computer and log in as administrator
- Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
- Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
- On the new confirmation window that appears, click Next
- 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.18.104.22.168
,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