{"id":11776,"date":"2022-03-20T15:56:29","date_gmt":"2022-03-20T08:56:29","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11776"},"modified":"2022-03-20T16:29:23","modified_gmt":"2022-03-20T09:29:23","slug":"cach-dinh-dang-so-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11776&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400\">.Trong cu\u1ed9c s\u1ed1ng \u0111\u1ec3 m\u1ecdi thao t\u00e1c t\u00ednh to\u00e1n v\u1edbi con s\u1ed1 \u0111\u01b0\u1ee3c di\u1ec5n ra thu\u1eadn ti\u1ec7n h\u01a1n b\u1ea1n c\u1ea7n c\u00f3 nh\u1eefng c\u00f4ng c\u1ee5 c\u0169ng nh\u01b0 c\u00f4ng c\u1ee5 l\u00e0m vi\u1ec7c tr\u00ean Excel. \u0110\u1eb7c bi\u1ec7t l\u00e0 <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/b><span style=\"font-weight: 400\"> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n th\u00ec \u0111\u00e2y l\u00e0 \u0111i\u1ec1u <a href=\"https:\/\/teky.edu.vn\/blog\/\"><strong>Teky<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y.\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Dinh_nghia_ve_dinh_dang_so\" >\u0110\u1ecbnh ngh\u0129a v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Co_nhat_thiet_phai_su_dung_cach_dinh_dang_so_trong_Excel\" >C\u00f3 nh\u1ea5t thi\u1ebft ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Huong_dan_thiet_lap_cach_dinh_dang_so_trong_excel\" >H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Huong_dan_cach_dinh_dang_so_trong_excel\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Mo_ta_ve_phan_dinh_dang_chung\" >M\u00f4 t\u1ea3 v\u1ec1 ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng chung:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Dinh_dang_so\" >\u0110\u1ecbnh d\u1ea1ng s\u1ed1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Dinh_dang_tien_te_ke_toan\" >\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7, k\u1ebf to\u00e1n<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Dinh_dang_tien_te\" >\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Dinh_dang_ke_toan\" >\u0110\u1ecbnh d\u1ea1ng k\u1ebf to\u00e1n<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#Dinh_dang_ngay_thang_thoi_gian\" >\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, th\u1eddi gian<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_nghia_ve_dinh_dang_so\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh ngh\u0129a v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 hay \u0111\u01b0\u1ee3c g\u1ecdi v\u1edbi t\u00ean Ti\u1ebfng Anh l\u00e0 Number Formats. \u0110\u00e2y l\u00e0 t\u00ednh n\u0103ng th\u1ec3 hi\u1ec7n <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/b><span style=\"font-weight: 400\">. N\u00f3 s\u1ebd cho ph\u00e9p b\u1ea1n bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u s\u1ed1 b\u1eb1ng c\u00e1ch \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00e1i nh\u00ecn bao qu\u00e1t v\u00e0 tr\u1ef1c quan v\u1ec1 v\u0103n b\u1ea3n \u0111ang th\u1ef1c hi\u1ec7n. Ngo\u00e0i ra, \u0111\u1ec3 bi\u1ebft b\u1ea1n \u0111ang s\u1eed d\u1ee5ng ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1 g\u00ec v\u00e0 nh\u01b0 th\u1ebf n\u00e0o th\u00ec \u0111\u00e2y s\u1ebd l\u00e0 c\u00f4ng d\u1ee5ng kh\u00e1c c\u1ee7a \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong b\u1ea3ng t\u00ednh b\u1ea1n \u0111ang thao t\u00e1c.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Co_nhat_thiet_phai_su_dung_cach_dinh_dang_so_trong_Excel\"><\/span><span style=\"font-weight: 400\">C\u00f3 nh\u1ea5t thi\u1ebft ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c<\/span><b> c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel <\/b><span style=\"font-weight: 400\">\u00a0th\u00ec b\u1ea1n tr\u01b0\u1edbc ti\u00ean ph\u1ea3i hi\u1ec3u \u0111\u01b0\u1ee3c b\u1ea1n n\u00ean d\u00f9ng n\u00f3 khi n\u00e0o v\u00e0 t\u1ea1i sao b\u1ea1n ph\u1ea3i d\u00f9ng n\u00f3 trong excel. C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 v\u1edbi nh\u1eefng th\u00f4ng tin s\u1ed1 ngo\u1eb1n ngo\u00e8o kh\u00f3 \u0111\u1ecdc kh\u00f3 hi\u1ec3u v\u00e0 kh\u00f3 n\u1eafm b\u1eaft th\u00f4ng tin<\/span><span style=\"font-weight: 400\">.\u00a0 <\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u00f3 s\u1ebd bi\u1ebfn h\u00f3a th\u00f4ng tin c\u1ee7a b\u1ea1n th\u00e0nh nh\u1eefng th\u1ee9 d\u1ec5 \u0111\u1ecdc h\u01a1n d\u1ec5 ch\u1ecbu h\u01a1n. M\u00e0 c\u00f2n gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng nh\u1eefng th\u00f4ng tin \u0111\u00f3 d\u1ec5 d\u00e0ng h\u01a1n, nhanh ch\u00f3ng h\u01a1n.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1eb3ng h\u1ea1n: B\u1ea1n \u0111ang b\u0103n kho\u0103n kh\u00f4ng bi\u1ebft ng\u00e0y n\u00e0o m\u00ecnh \u0111\u00e3 \u0111\u0103ng nh\u1eadp v\u00e0o b\u1ea3ng t\u00ednh. Th\u00ec b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng <\/span>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng <span style=\"font-weight: 400\">\u00a0Date Format.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_thiet_lap_cach_dinh_dang_so_trong_excel\"><\/span><span style=\"font-weight: 400\">H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: B\u1ea1n click v\u00e0 ch\u1ecdn tab Home, ti\u1ebfp theo th\u1ea3 chu\u1ed9t nh\u1eb9 nh\u00e0ng xong ch\u1ecdn Number Format \u1edf m\u1ee5c Number. Cu\u1ed1i c\u00f9ng b\u1ea1n s\u1ebd t\u00f9y \u00fd l\u1ef1a ch\u1ecdn m\u1ee9c \u0111\u1ecbnh d\u1ea1ng m\u00e0 ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u b\u1ea1n \u0111\u1eb7t ra.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11793 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-1.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5 \u1edf tr\u00ecnh \u0111\u01a1n b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh nhanh. V\u00e0 nh\u1ea5p v\u00e0o ch\u1ecdn th\u1ebf l\u00e0 thao t\u00e1c ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111\u00e3 xong.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11792 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: Khi b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng<\/span><b> c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong excel <\/b>h\u00e3y<span style=\"font-weight: 400\">\u00a0nh\u1ea5p v\u00e0 ch\u1ecdn k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 d\u00e0nh cho c\u00e1c ch\u1eef s\u1ed1 \u1edf trong b\u1ea3ng excel. Thao t\u00e1c n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch ch\u1ecdn v\u00e0o h\u00ecnh ti\u1ec1n t\u1ec7 \u0111\u01b0\u1ee3c \u0111\u1eb7t s\u1eb5n \u1edf tr\u00ecnh \u0111\u01a1n \u0111\u01b0\u1ee3c th\u1ea3 xu\u1ed1ng.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11790 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng sau khi c\u00e1c thao t\u00e1c \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ho\u00e0n ch\u1ec9nh. \u0110\u00fang ra h\u01a1n l\u00e0 ch\u1ecdn \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 theo \u0111\u01a1n v\u1ecb ti\u1ec1n Anh. B\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a thao t\u00e1c c\u00e1ch \u0111\u1ecbnh \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11791 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_dinh_dang_so_trong_excel\"><\/span><span style=\"font-weight: 400\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Mo_ta_ve_phan_dinh_dang_chung\"><\/span><span style=\"font-weight: 400\">M\u00f4 t\u1ea3 v\u1ec1 ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng chung:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng ki\u1ec3u m\u1eb7c \u0111\u1ecbnh m\u00e0 excel \u0111\u00e3 thi\u1ebft l\u1eadp l\u00e0 khi b\u1ea1n b\u1eaft \u0111\u1ea7u th\u1ef1c hi\u1ec7n vi\u1ec7c nh\u1eadp m\u1ed9t con s\u1ed1 n\u00e0o \u0111\u00f3. Ph\u1ea7n l\u1edbn c\u00e1c tr\u01b0\u1eddng h\u1ee3p \u0111\u01b0\u1ee3c di\u1ec5n ra th\u00ec s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng chung. N\u1ebfu nh\u01b0 b\u1ea1n nh\u1eadp c\u00e1ch \u0111\u00fang th\u00ec n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u0111\u00fang. <\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb7t kh\u00e1c, vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 c\u00e1c th\u1eadp ph\u00e2n s\u1ebd \u0111\u01b0\u1ee3c di\u1ec5n ra n\u1ebfu m\u1ed9t \u00f4 tr\u00ean m\u00e1y c\u1ee7a b\u1ea1n. Kh\u00f4ng c\u00f3 \u0111\u1ee7 \u0111\u1ed9 r\u1ed9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb l\u00ean \u0111\u1ea7y \u0111\u1ee7 nh\u1eefng con s\u1ed1 th\u00ec n\u00f3 s\u1ebd m\u1eb7c \u0111\u1ecbnh thao t\u00e1c l\u00e0m tr\u00f2n s\u1ed1. \u0110\u1ed1i v\u1edbi nh\u1eefng con s\u1ed1 mang gi\u00e1 tr\u1ecb l\u1edbn th\u01b0\u1eddng c\u00f3 12 ch\u1eef s\u1ed1 tr\u1edf l\u00ean. S\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng theo k\u00fd hi\u1ec7u khoa h\u1ecdc c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi kh\u00e1c l\u00e0 h\u00e0m m\u0169.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_so\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u00f4 t\u1ea3:<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u00a0M\u1ee5c \u0111\u00edch ch\u00ednh c\u1ee7a n\u00f3 l\u00e0 hi\u1ec3n th\u1ecb c\u00e1c ch\u1eef s\u1ed1 n\u00f3i chung. Khi s\u1eed d\u1ee5ng<\/span><b> c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel <\/b><span style=\"font-weight: 400\">n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u01b0\u1ee3c r\u00f5 t\u1eebng v\u1ecb tr\u00ed th\u1eadp ph\u00e2n v\u1edbi con s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng. Hay l\u00e0 vi\u1ec7c b\u1ea1n t\u00e1ch c\u00e1c con s\u1ed1 h\u00e0ng tr\u0103m h\u00e0ng ngh\u00ecn hay kh\u00f4ng ho\u1eb7c b\u1ea1n mu\u1ed1n c\u1ea3 s\u1ed1 \u00e2m \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb l\u00ean b\u1ea3ng t\u00ednh.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: Tr\u01b0\u1edbc ti\u00ean b\u1ea1n h\u00e3y ch\u1ecdn v\u00e0 b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n \u0111ang c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11787 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Ti\u1ebfp theo d\u00f9ng chu\u1ed9t ph\u1ea3i nh\u1ea5p v\u00e0 ch\u1ecdn t\u1eeb Format Cells.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11789 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: H\u00e3y s\u1eed d\u1ee5ng<\/span><b> c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/b><span style=\"font-weight: 400\"> l\u00e0 ch\u1ecdn Number d\u00e0nh cho thao t\u00e1c \u0111\u1ecbnh d\u1ea1ng ri\u00eang c\u1ee7a s\u1ed1. Cu\u1ed1i c\u00f9ng ch\u1ecdn v\u00e0o Use 1000 Separator nh\u01b0 h\u00ecnh \u0111\u01b0\u1ee3c \u0111\u01b0a ra \u0111\u1ec3 excel s\u1ebd l\u00e0m vi\u1ec7c v\u00e0 t\u1ef1 \u0111\u1ed9ng th\u00eam nh\u1eefng d\u1ea5u ph\u1ea9y sau m\u1ed7i 2 ch\u1eef s\u1ed1 c\u1ee7a b\u1ea1n.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11788 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 4: Ch\u1ecdn Enter \u0111\u1ec3 k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c nh\u1eadn k\u1ebft qu\u1ea3 theo mong mu\u1ed1n c\u1ee7a m\u00ecnh nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11785 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-4.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_tien_te_ke_toan\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7, k\u1ebf to\u00e1n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_tien_te\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u00f4 t\u1ea3: M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/b><span style=\"font-weight: 400\"> n\u00e0y l\u00e0 nh\u1eb1m d\u00e0nh cho gi\u00e1 tr\u1ecb ti\u1ec1n t\u1ec7 n\u00f3i chung v\u00e0 s\u1ebd \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh bi\u1ec3u t\u01b0\u1ee3ng ti\u1ec1n t\u1ec7 v\u1edbi nh\u1eefng con s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ec9 r\u00f5 t\u1eebng v\u1ecb tr\u00ed c\u1ee7a con s\u1ed1 th\u1eadp ph\u00e2n. Khi b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng v\u1edbi m\u1ee5c \u0111\u00edch c\u1ee7a m\u00ecnh. Ho\u1eb7c c\u00e1c s\u1ed1 \u00e2m ho\u1eb7c vi\u1ec7c t\u00e1ch h\u00e0ng ngh\u00ecn ra kh\u00f4ng \u0111\u1ec1u \u0111\u01b0\u1ee3c, t\u00f9y b\u1ea1n l\u1ef1a ch\u1ecdn.\u00a0<\/span><\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_ke_toan\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng k\u1ebf to\u00e1n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong excel <\/b><span style=\"font-weight: 400\">nh\u01b0ng h\u01a1i chuy\u00ean s\u00e2u v\u00e0o ng\u00e0nh k\u1ebf to\u00e1n m\u1ed9t \u00edt. N\u00f3 c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ti\u1ec1n t\u1ec7. Nh\u01b0ng n\u00f3 ch\u1ec9 d\u00e0nh cho m\u1ed9t kh\u00f4ng gian h\u1eb9p c\u1ee5 th\u1ec3 l\u00e0 trong m\u1ed9t c\u1ed9t. C\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ti\u1ec1n t\u1ec7 v\u00e0 k\u1ebf to\u00e1n<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: B\u1ea1n c\u0169ng c\u1ea7n ch\u1ecdn v\u00e0 b\u00f4i v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11786 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Nh\u1ea5n v\u00e0 ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh $ \u1edf thanh c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c th\u1ea3 xu\u1ed1ng. Sau \u0111\u00f3 ch\u1ecdn ki\u1ec3u \u0111\u01a1n v\u1ecb m\u00e0 m\u00ecnh mu\u1ed1n s\u1eed d\u1ee5ng.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11784 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-7.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-7-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-7-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: T\u00f9y theo ki\u1ec3u m\u00e0 b\u1ea1n ch\u1ecdn s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c \u0111\u01a1n v\u1ecb hi\u1ec3n th\u1ecb t\u01b0\u01a1ng \u1ee9ng. Do \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn theo \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 l\u00e0 Anh n\u00ean k\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11783 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-7.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-7-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-7-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_ngay_thang_thoi_gian\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, th\u1eddi gian<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u00f4 t\u1ea3:\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Theo v\u1ecb tr\u00ed m\u00e0 b\u1ea1n \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh trong m\u00e1y. Th\u00ec s\u1ed1 seri c\u1ee7a ng\u00e0y v\u00e0 gi\u1edd s\u1ebd hi\u1ec3n th\u1ecb theo d\u1ea1ng gi\u00e1 tr\u1ecb \u0111\u00f3, t\u00f9y theo m\u1ed7i \u0111\u1ecba \u0111i\u1ec3m. M\u1ed7i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y s\u1ebd \u0111\u01b0\u1ee3c b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u sao *. C\u00f3 th\u1ec3 \u0111\u00e1p \u1ee9ng t\u1ed1t s\u1ef1 thay \u0111\u1ed5i trong khi thi\u1ebft l\u1eadp ng\u00e0y v\u00e0 th\u1eddi gian. Tuy nhi\u00ean, nh\u1eefng \u0111\u1ecbnh d\u1ea1ng m\u00e0 kh\u00f4ng c\u00f3 d\u1ea5u sao s\u1ebd kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng trong qu\u00e1 tr\u00ecnh \u0111i\u1ec1u khi\u1ec3n.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng:<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: B\u1ea1n nh\u1ea5n ch\u1ecdn c\u00e1c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m m\u00e0 b\u1ea1n \u0111ang mu\u1ed1n s\u1eed d\u1ee5ng v\u1edbi excel c\u1ee7a m\u00ecnh. Sau c\u00f9ng l\u00e0 nh\u1ea5n Enter.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11782 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-6.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-6-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-6-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Theo nh\u1eefng \u0111\u1ecbnh d\u1ea1ng \u0111\u00e3 ch\u1ecdn t\u1eeb tr\u01b0\u1edbc th\u00ec b\u1ea1n s\u1ebd nh\u1eadp ng\u00e0y, th\u00e1ng, n\u0103m.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11781 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-7.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-7-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-7-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: B\u1ea1n s\u1ebd l\u00e0m xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng b\u1eb1ng c\u00e1ch k\u00e9o nh\u1eb9 chu\u1ed9t xu\u1ed1ng \u00f4 cu\u1ed1i c\u1ee7a ng\u00e0y th\u00e1ng n\u0103m. Ch\u1ecdn d\u1ea5u c\u1ed9ng v\u1eeba xu\u1ea5t hi\u1ec7n \u0111\u1ec3 k\u00e9o xu\u1ed1ng nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11780 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft tr\u00ean l\u00e0 t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec chi ti\u1ebft nh\u1ea5t v\u1ec1 <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel <\/b><span style=\"font-weight: 400\">hay l\u00e0 <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong excel<\/b><span style=\"font-weight: 400\">. Mong b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n \u0111\u00fang h\u01b0\u1edbng d\u1eabn v\u00e0 th\u00e0nh c\u00f4ng khi th\u1ef1c hi\u1ec7n theo.\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/cach-mo-khoa-file-excel\/\"><em><strong><span style=\"color: #0000ff\">C\u00e1ch m\u1edf kh\u00f3a file Excel<\/span><\/strong><\/em><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>.Trong cu\u1ed9c s\u1ed1ng \u0111\u1ec3 m\u1ecdi thao t\u00e1c t\u00ednh to\u00e1n v\u1edbi con s\u1ed1 \u0111\u01b0\u1ee3c di\u1ec5n ra thu\u1eadn ti\u1ec7n h\u01a1n b\u1ea1n c\u1ea7n c\u00f3 nh\u1eefng c\u00f4ng c\u1ee5 c\u0169ng nh\u01b0 c\u00f4ng c\u1ee5 l\u00e0m vi\u1ec7c tr\u00ean Excel. \u0110\u1eb7c bi\u1ec7t l\u00e0 c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11779,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n.. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ch\u00fang t\u00f4i s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel n\u00e0y.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n.. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ch\u00fang t\u00f4i s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel n\u00e0y.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-20T08:56:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-20T09:29:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t\",\"datePublished\":\"2022-03-20T08:56:29+00:00\",\"dateModified\":\"2022-03-20T09:29:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\"},\"wordCount\":1899,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg\",\"datePublished\":\"2022-03-20T08:56:29+00:00\",\"dateModified\":\"2022-03-20T09:29:23+00:00\",\"description\":\"B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n.. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ch\u00fang t\u00f4i s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel n\u00e0y.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t","description":"B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n.. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ch\u00fang t\u00f4i s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel n\u00e0y.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t","og_description":"B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n.. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ch\u00fang t\u00f4i s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel n\u00e0y.\u00a0","og_url":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-20T08:56:29+00:00","article_modified_time":"2022-03-20T09:29:23+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t","datePublished":"2022-03-20T08:56:29+00:00","dateModified":"2022-03-20T09:29:23+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/"},"wordCount":1899,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg","datePublished":"2022-03-20T08:56:29+00:00","dateModified":"2022-03-20T09:29:23+00:00","description":"B\u1ea1n mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 bi\u1ebfn n\u00f3 tr\u1edf n\u00ean d\u1ec5 ch\u1ecbu h\u01a1n ch\u00ednh x\u00e1c h\u01a1n.. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ch\u00fang t\u00f4i s\u1ebd gi\u00fap b\u1ea1n th\u00f4ng qua b\u00e0i vi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel n\u00e0y.\u00a0","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-7.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel m\u1edbi nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11776"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11776\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11779"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}