excel輸入身份證號(hào)變成0解決方法-Excel教程-辦公軟件

nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">在公司、學(xué)校，經(jīng)常會(huì)遇到需要在Excel錄入身份證號(hào)的場景，但錄入完畢會(huì)發(fā)現(xiàn)身份證號(hào)成了科學(xué)統(tǒng)計(jì)法，再次點(diǎn)擊發(fā)現(xiàn)最后三位成了“0”,這個(gè)如何解決呢？nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;text-align:center;">nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">規(guī)規(guī)矩矩的輸入18位數(shù)字nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;text-align:center;">nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">最后三位成了“0”nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">究其原因，就是Excel目前最多支持15位數(shù)字，超過的數(shù)字全部默認(rèn)為“0”，ng>解決方法很簡單，將格式由“數(shù)值”改為“文本”。ng>因?yàn)樯矸葑C號(hào)作為一串固定的數(shù)字并沒有運(yùn)算需求，應(yīng)該歸屬于規(guī)規(guī)矩矩的文本。nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">ng>方法一ng>：先在表格中輸入英文半角的“’”號(hào)〔冒號(hào)后面那個(gè)鍵〕，其作用就是將該表格項(xiàng)的屬性改為“文本”。nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;text-align:center;">nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">ng>方法二ng>：如果一時(shí)記不起先輸入哪個(gè)符號(hào)的話，有個(gè)更通用的方法，在“工具欄”下拉格式列表，點(diǎn)擊最下方的“文本”就行了。nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;text-align:center;">nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;">ng>方法三ng>：在選定的單元格右鍵，選擇“設(shè)置單元格格式”，在“數(shù)字”標(biāo)簽中選擇“文本”后點(diǎn)擊確定即可。nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;orphans:auto;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:0px;-webkit-text-stroke-width:0px;text-align:center;">nt-family:宋體,Arial;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;le