{"id":12156,"date":"2025-01-15T07:24:40","date_gmt":"2025-01-15T07:24:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/4-cach-de-nhap-so-dien-thoai-trong-excel-ma-khong-mat-so-0\/"},"modified":"2025-01-15T07:24:40","modified_gmt":"2025-01-15T07:24:40","slug":"4-cach-de-nhap-so-dien-thoai-trong-excel-ma-khong-mat-so-0","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/4-cach-de-nhap-so-dien-thoai-trong-excel-ma-khong-mat-so-0\/","title":{"rendered":"4 c\u00e1ch \u0111\u1ec3 nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel m\u00e0 kh\u00f4ng m\u1ea5t s\u1ed1 0"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><strong>Trong khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel, ch\u00fang ta v\u1eabn th\u01b0\u1eddng hay g\u1eb7p s\u1ef1 c\u1ed1 m\u1ea5t \u0111i s\u1ed1 0 \u1edf \u0111\u1ea7u ti\u00ean, v\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp \u0111\u01b0\u1ee3c \u0111\u1ea7y \u0111\u1ee7 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng.<\/strong><\/em><\/p>\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n 4 c\u00e1ch nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u01a1n gi\u1ea3n:<\/p>\n<p><strong>C\u00e1ch 1<\/strong>: \u0110\u1ecbnh d\u1ea1ng \u00f4 ch\u1ee9a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i sang <strong>Text<\/strong><\/p>\n<ul>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 c\u00f3 ch\u1ee9a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, ch\u1ecdn <strong>Format Cells \u00a0<\/strong>r\u1ed3i ch\u1ecdn <strong>Text<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4101 aligncenter\" src=\"https:\/\/www.hocexcel.online\/wp-content\/uploads\/2017\/04\/bai-tap-excel-3.png\" alt=\"\" width=\"600\" height=\"424\"><\/p>\n<ul>\n<li>Nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4102 aligncenter\" src=\"https:\/\/www.hocexcel.online\/wp-content\/uploads\/2017\/04\/bai-tap-excel-4.png\" alt=\"\" width=\"600\" height=\"376\"><\/p>\n<p><strong>C\u00e1ch 2:\u00a0<\/strong>Nh\u1eadp th\u00eam d\u1ea5u \u201c-\u201d ho\u1eb7c d\u1ea5u \u201c.\u201d v\u00e0o trong s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u s\u1ed1 th\u00e0nh d\u1ea1ng chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4104 aligncenter\" src=\"https:\/\/www.hocexcel.online\/wp-content\/uploads\/2017\/04\/bai-tap-excel-5.png\" alt=\"\" width=\"600\" height=\"365\"><\/p>\n<p><strong>C\u00e1ch 3<\/strong>: Th\u00eam d\u1ea5u <strong>\u2018<\/strong> \u1edf tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ea7n nh\u1eadp.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-359.gif\" title=\"ex101_92019-nho-359\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4105 aligncenter\" src=\"https:\/\/www.hocexcel.online\/wp-content\/uploads\/2017\/04\/bai-tap-excel-6.png\" alt=\"\" width=\"600\" height=\"369\"><\/p>\n<p><strong>C\u00e1ch 4<\/strong>: Nh\u1eadp th\u00eam d\u1ea5u c\u00e1ch \u1edf gi\u1eefa c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u0169ng l\u00e0 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4106 aligncenter\" src=\"https:\/\/www.hocexcel.online\/wp-content\/uploads\/2017\/04\/bai-tap-excel-7.png\" alt=\"\" width=\"600\" height=\"363\"><\/p>\n<p><strong>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m<\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-tru-thoi-gian-de-tinh-luong-dung-trong-excel.html\">C\u00e1ch nh\u1eadp d\u1eef li\u1ec7u v\u00e0 tr\u1eeb th\u1eddi gian \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \u0111\u00fang trong Excel<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-nhap-cong-thuc-hoa-hoc-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>C\u00e1ch nh\u1eadp c\u00f4ng th\u1ee9c h\u00f3a h\u1ecdc trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"https:\/\/www.hocexcel.online\/ham-choose-trong-excel.html\">H\u00e0m CHOOSE trong Excel<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/www.hocexcel.online\/ham-dget-ham-trich-mot-gia-tri-tu-co-du-lieu-khop-voi-dieu-kien-trong-excel.html\">H\u00e0m DGET \u2013 H\u00e0m tr\u00edch m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u1edbp v\u1edbi \u0111i\u1ec1u ki\u1ec7n trong Excel.<\/a><\/strong><\/p>\n<p>\u2014\u2014\u2014<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-359.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12157,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12156"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12157"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}