{"id":6579,"date":"2024-12-21T15:39:33","date_gmt":"2024-12-21T15:39:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/dinh-dang-du-lieu-toan-tap-trong-excel\/"},"modified":"2024-12-21T15:39:33","modified_gmt":"2024-12-21T15:39:33","slug":"dinh-dang-du-lieu-toan-tap-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/dinh-dang-du-lieu-toan-tap-trong-excel\/","title":{"rendered":"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u to\u00e0n t\u1eadp trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766e13425d8f\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_du_lieu_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel:\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_du_lieu_co_ban_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u01a1 b\u1ea3n trong Excel:\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u01a1 b\u1ea3n trong Excel:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Co_toi_4_cach_de_mo_hop_thoai_Format_Cells\" title=\"C\u00f3 t\u1edbi 4 c\u00e1ch \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells\">C\u00f3 t\u1edbi 4 c\u00e1ch \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Co_toi_6_the_can_quan_tam_trong_hop_thoai_Format_Cells\" title=\"C\u00f3 t\u1edbi 6 th\u1ebb c\u1ea7n quan t\u00e2m trong h\u1ed9p tho\u1ea1i Format Cells\">C\u00f3 t\u1edbi 6 th\u1ebb c\u1ea7n quan t\u00e2m trong h\u1ed9p tho\u1ea1i Format Cells<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_so_%E2%80%93_Number\" title=\"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u2013 Number\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u2013 Number<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_tien_te_va_ke_toan\" title=\"\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u00e0 k\u1ebf to\u00e1n\">\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u00e0 k\u1ebf to\u00e1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_ngay_thang_va_thoi_gian\" title=\"\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian:\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_phan_tram_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m trong Excel:\">\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_phan_so_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng ph\u00e2n s\u1ed1 trong Excel:\">\u0110\u1ecbnh d\u1ea1ng ph\u00e2n s\u1ed1 trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_khoa_hoc\" title=\"\u0110\u1ecbnh d\u1ea1ng khoa h\u1ecdc:\">\u0110\u1ecbnh d\u1ea1ng khoa h\u1ecdc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_du_lieu_kieu_chu\" title=\"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef:\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_dac_biet_%E2%80%93_Special\" title=\"\u0110\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t \u2013 Special:\">\u0110\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t \u2013 Special:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Dinh_dang_cua_nguoi_dung_%E2%80%93_Custom\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u2013 Custom\">\u0110\u1ecbnh d\u1ea1ng c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u2013 Custom<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html#Mot_so_video_lien_quan_den_viec_su_dung_dinh_dang_du_lieu_trong_Excel\" title=\"M\u1ed9t s\u1ed1 video lien quan \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel:\">M\u1ed9t s\u1ed1 video lien quan \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_dang_du_lieu_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng c\u00f3 ph\u1ee5 n\u1eef x\u1ea5u, ch\u1ec9 c\u00f3 ng\u01b0\u1eddi photoshop kh\u00f4ng \u0111\u1eb9p. Kh\u00f4ng c\u00f3 b\u1ea3ng Excel x\u1ea5u, ch\u1ec9 c\u00f3 ng\u01b0\u1eddi tr\u00ecnh b\u00e0y kh\u00f4ng \u0111\u1eb9p.<\/p>\n<p>H\u00f4m nay, ch\u00fang ta s\u1ebd \u0111i th\u0103m m\u1ed9t ch\u1ee7 \u0111\u1ec1 v\u1ec1 l\u00e0m \u0111\u1eb9p \u2013 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel. Nh\u1eefng th\u1ee7 thu\u1eadt n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho c\u00e1c phi\u00ean b\u1ea3n Excel 2003, Excel 2007, Excel 2010, Excel 2013 v\u00e0 Excel 2016 tr\u1edf l\u00ean.<\/p>\n<p><strong>V\u1ec1 c\u01a1 b\u1ea3n th\u00ec Excel h\u1ed7 tr\u1ee3 ch\u00fang ta nh\u1eefng ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng sau \u0111\u00e2y:<\/strong><\/p>\n<ol>\n<li>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 (Number)<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng ch\u1eef (Text)<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 (Currency)<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m (Percentage)<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng trong k\u1ebf to\u00e1n (Accounting)<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 trong khoa h\u1ecdc (Scientific)<\/li>\n<li>\u0110\u1ecbnh d\u1ea1ng ng\u01b0\u1eddi d\u00f9ng t\u1ef1 \u0111\u1ecbnh ngh\u0129a (Custom)<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_dang_du_lieu_co_ban_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u01a1 b\u1ea3n trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_537\" aria-describedby=\"caption-attachment-537\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/Screen-Shot-2016-07-07-at-07.32.39.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-537 size-medium\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-07-at-07-32-39-300x221-1.png\" alt=\"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u01a1 b\u1ea3n\" width=\"300\" height=\"221\" title=\"screen-shot-2016-07-07-at-07-32-39-300x221-1\"><\/a><figcaption id=\"caption-attachment-537\" class=\"wp-caption-text\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u01a1 b\u1ea3n<\/figcaption><\/figure>\n<p>M\u1eb7c \u0111\u1ecbnh th\u00ec Excel s\u1ebd lu\u00f4n \u0111\u1ecbnh d\u1ea1ng b\u1ea5t k\u00ec nh\u1eefng g\u00ec b\u1ea1n g\u00f5 v\u00e0o 1 \u00f4 v\u1edbi ki\u1ec3u <strong>General. <\/strong>Excel c\u0169ng h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng m\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m ngay v\u00e0o \u00f4 Format nh\u01b0 tr\u00ean h\u00ecnh v\u00e0 tr\u1ecdn. Trong h\u00ecnh minh ho\u1ea1, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c, c\u00f9ng 1 d\u1eef li\u1ec7u \u2013 con s\u1ed1\u00a0<strong>0,234<\/strong>, v\u1edbi m\u1ed7i ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ch\u00fang ta s\u1ebd th\u1ea5y con s\u1ed1 n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n kh\u00e1c \u0111i.<\/p>\n<p><del><\/del><strong>Th\u1ee7 thu\u1eadt:<\/strong> mu\u1ed1n bi\u1ebft \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u th\u1ef1c s\u1ef1 \u0111\u1eb1ng sau 1 \u00f4 l\u00e0 g\u00ec, ch\u00fang ta c\u1ea7n nh\u00ecn v\u00e0o thanh c\u00f4ng th\u1ee9c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Co_toi_4_cach_de_mo_hop_thoai_Format_Cells\"><\/span>C\u00f3 t\u1edbi 4 c\u00e1ch \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Format Cells. C\u00f3 4 c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 m\u1edf \u0111\u01b0\u1ee3c h\u1ed9p tho\u1ea1i n\u00e0y nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn v\u00f9ng c\u1ea7n \u0111\u1ecbnh d\u1ea1ng v\u00e0 b\u1ea5m ph\u00edm t\u1eaft <strong>CTRL + 1 <\/strong>(Nh\u1eabn gi\u1eef CTRL v\u00e0 b\u1ea5m s\u1ed1 1)<\/li>\n<li>Chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng c\u1ea7n \u0111\u1ecbnh d\u1ea1ng v\u00e0 ch\u1ecdn trong menu n\u00e0y <strong><strong><strong><strong>Format Cells\u2026<\/strong><\/strong><\/strong><\/strong><br \/>\n<figure id=\"attachment_539\" aria-describedby=\"caption-attachment-539\" style=\"width: 205px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/zformat-cells-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-539\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/zformat-cells-excel.png\" alt=\"menu chu\u1ed9t ph\u1ea3i format cells\" width=\"205\" height=\"401\" title=\"zformat-cells-excel\"><\/a><figcaption id=\"caption-attachment-539\" class=\"wp-caption-text\">menu chu\u1ed9t ph\u1ea3i format cells<\/figcaption><\/figure>\n<p><strong><strong>\u00a0<\/strong><\/strong><\/p>\n<\/li>\n<li>B\u1ea5m v\u00e0o v\u1ecb tr\u00ed c\u00e1c m\u0169i t\u00ean \u1edf \u0111\u00e3 \u0111\u01b0\u1ee3c khoanh tr\u00f2n \u0111\u1ecf nh\u01b0 trong h\u00ecnh v\u1ebd\n<p><figure id=\"attachment_540\" aria-describedby=\"caption-attachment-540\" style=\"width: 612px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/open-format-cells-dialog.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-540\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/open-format-cells-dialog.png\" alt=\"M\u1edf h\u1ed9p tho\u1ea1i Format Cells\" width=\"612\" height=\"123\" title=\"open-format-cells-dialog\"><\/a><figcaption id=\"caption-attachment-540\" class=\"wp-caption-text\">M\u1edf h\u1ed9p tho\u1ea1i Format Cells<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<li>Trong th\u1ebb <strong>Home<\/strong>, \u00a0ch\u1ecdn <strong>Format\u00a0<\/strong>r\u1ed3i ch\u1ecdn Format Cells \u2026<br \/>\n<figure id=\"attachment_541\" aria-describedby=\"caption-attachment-541\" style=\"width: 179px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/open-format-cells-dialog2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-541\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/open-format-cells-dialog2.png\" alt=\"M\u1edf h\u1ed9p tho\u1ea1i Format Cells\" width=\"179\" height=\"481\" title=\"open-format-cells-dialog2\"><\/a><figcaption id=\"caption-attachment-541\" class=\"wp-caption-text\">M\u1edf h\u1ed9p tho\u1ea1i Format Cells<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Co_toi_6_the_can_quan_tam_trong_hop_thoai_Format_Cells\"><\/span>C\u00f3 t\u1edbi 6 th\u1ebb c\u1ea7n quan t\u00e2m trong h\u1ed9p tho\u1ea1i Format Cells<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi \u0111\u00e3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells r\u1ed3i, ch\u00fang ta s\u1ebd th\u1ea5y 6 th\u1ebb \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng h\u1ea7u nh\u01b0 to\u00e0n b\u1ed9 m\u1ed9t v\u00f9ng trong Excel:<\/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\/2024\/12\/ex101_92019-nho-588.gif\" title=\"ex101_92019-nho-588\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Th\u1ebb Number<\/li>\n<li>Th\u1ebb Alignment<\/li>\n<li>Th\u1ebb Font<\/li>\n<li>Th\u1ebb Border<\/li>\n<li>Th\u1ebb Fill<\/li>\n<li>Th\u1ebb Protection<\/li>\n<\/ul>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 th\u1ebb <strong>Number<\/strong> \u2013 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 li\u1ec7u.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_so_%E2%80%93_Number\"><\/span>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u2013 Number<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-number-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-544\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-number-format.png\" alt=\"excel-number-format\" width=\"541\" height=\"471\" title=\"excel-number-format\"><\/a><\/p>\n<p>Trong th\u1ebb Number, m\u1ee5c Categories b\u00ean tay tr\u00e1i, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c l\u1ea7n l\u01b0\u1ee3t c\u00e1c l\u1ef1a ch\u1ecdn \u0111\u1ec3 ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel.<\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-su-dung-custom-format.html\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Custom Format<\/a><\/p>\n<p>Trong m\u1ee5c n\u00e0y, m\u1ed7i ph\u1ea7n b\u00ean tay ph\u1ea3i l\u1ea7n l\u01b0\u1ee3t c\u00f3 \u00fd ngh\u0129a l\u00e0:<\/p>\n<ol>\n<li><strong>Sample<\/strong>: cho ch\u00fang ta xem tr\u01b0\u1edbc, s\u1ef1 thay \u0111\u1ed5i trong \u0111\u1ecbnh d\u1ea1ng s\u1ebd \u1ea3nh h\u01b0\u1edfng l\u00ean d\u1eef li\u1ec7u th\u1ebf n\u00e0o<\/li>\n<li><strong>Decimal places<\/strong>: d\u00f9ng \u0111\u1ec3 ch\u1ec9 ra ch\u00fang ta c\u1ea7n bao nhi\u00eau ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y \u1edf ph\u1ea7n th\u1eadp ph\u00e2n<\/li>\n<li>D\u1ea5u t\u00edch \u1edf m\u1ee5c <strong>Use 1000 Separator (,)<\/strong>: n\u1ebfu c\u1ea7n ng\u0103n c\u00e1ch h\u00e0ng ngh\u00ecn, b\u1ea1n c\u1ea7n \u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o \u0111\u00e2y<\/li>\n<li><strong>Negative numbers<\/strong>: s\u1ebd gi\u00fap b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh m\u1ed9t s\u1ed1 \u00e2m s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0o<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_tien_te_va_ke_toan\"><\/span>\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u00e0 k\u1ebf to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u00e0 k\u1ebf to\u00e1n, b\u1ea1n c\u00f3 2 s\u1ef1 l\u1ef1a ch\u1ecdn<br \/>\n<strong>Decimal places:<\/strong> nh\u01b0 ph\u00eda tr\u00ean \u0111\u00e3 gi\u1ea3i th\u00edch, ph\u1ea7n n\u00e0y cho bi\u1ebft ch\u00fang ta c\u1ea7n bao nhi\u00eau ch\u1eef s\u1ed1 \u0111\u1eb1ng sau d\u1ea5u ph\u1ea9y<br \/>\n<strong>Symbol:<\/strong> K\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 m\u00e0 ch\u00fang ta mu\u1ed1n s\u1eed d\u1ee5ng<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/accounting-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-546\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/accounting-format.png\" alt=\"accounting-format\" width=\"541\" height=\"471\" title=\"accounting-format\"><\/a><\/p>\n<p>S\u1ef1 kh\u00e1c nhau gi\u1eefa ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u00e0 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng k\u1ebf to\u00e1n l\u00e0: v\u1edbi ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7, k\u00fd hi\u1ec7u \u0111\u1ed3ng ti\u1ec1n s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft li\u1ec1n ngay ph\u00eda tr\u01b0\u1edbc con s\u1ed1, v\u1edbi ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng k\u1ebf to\u00e1n, k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 s\u1ebd \u0111\u01b0\u1ecdc vi\u1ebft theo 1 h\u00e0ng c\u0103n l\u1ec1 ph\u00eda b\u00ean tr\u00e1i<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/currency-accounting-format-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/currency-accounting-format-excel.png\" alt=\"currency-accounting-format-excel\" width=\"353\" height=\"160\" title=\"currency-accounting-format-excel\"><\/a><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0H<span data-sheets-value='{\"1\":2,\"2\":\"h\u1ecdc excel k\u1ebf to\u00e1n\"}' data-sheets-userformat='{\"2\":513,\"3\":[null,0],\"12\":0}'>\u1ecdc excel k\u1ebf to\u00e1n<\/span><\/p>\n<\/blockquote>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_ngay_thang_va_thoi_gian\"><\/span>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong Excel r\u1ea5t phong ph\u00fa, l\u00fd do l\u00e0 v\u00ec m\u1ed7i n\u01b0\u1edbc tr\u00ean th\u1ebf gi\u1edbi c\u00f3 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian ri\u00eang v\u00e0 Excel h\u1ed7 tr\u1ee3 h\u1ea7u h\u1ebft c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3. Vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 c\u00e1c b\u1ea1n s\u1ebd ph\u1ea3i t\u00ecm \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p qua s\u1ef1 l\u1ef1a ch\u1ecdn trong danh s\u00e1ch <strong>Locale (Location)<\/strong> v\u00e0 <strong>Type<\/strong> c\u1ee7a Excel nh\u01b0 trong h\u00ecnh m\u00e0 th\u00f4i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-date-format-png.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-date-format-png.png\" alt=\"excel-date-format.png\" width=\"541\" height=\"471\" title=\"excel-date-format-png\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_phan_tram_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m n\u00e0y ch\u1ec9 cho ph\u00e9p b\u1ea1n thay \u0111\u1ed5i 1 l\u1ef1a ch\u1ecdn, \u0111\u00f3 l\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1eb1ng sau d\u1ea5u ph\u1ea9y<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_phan_so_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng ph\u00e2n s\u1ed1 trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng n\u00e0y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n vi\u1ebft ph\u00e2n s\u1ed1 trong Excel. L\u01b0u \u00fd l\u00e0 khi b\u1ea1n mu\u1ed1n nh\u1eadp d\u1eef li\u1ec7u l\u00e0 ph\u00e2n s\u1ed1 trong Excel, b\u1ea1n kh\u00f4ng th\u1ec3 nh\u1eadp \u0111\u01b0\u1ee3c tr\u1ef1c ti\u1ebfp ph\u00e2n s\u1ed1 \u0111\u00f3. VD: \u0111\u1ec3 nh\u1eadp ph\u00e2n s\u1ed1 \u201c<strong>1\/4<\/strong>\u201d th\u00ec b\u1ea1n ph\u1ea3i nh\u1eadp v\u00e0o <strong>0,25<\/strong> r\u1ed3i s\u1eed d\u1ee5ng t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng ph\u00e2n s\u1ed1 c\u1ee7a Excel.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-fraction-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-fraction-format.png\" alt=\"excel-fraction-format\" width=\"541\" height=\"471\" title=\"excel-fraction-format\"><\/a><\/p>\n<h3><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_khoa_hoc\"><\/span>\u0110\u1ecbnh d\u1ea1ng khoa h\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ecbnh d\u1ea1ng khoa h\u1ecdc l\u00e0 c\u00e1ch Excel d\u00f9ng \u0111\u1ec3 g\u1ecdi khi bi\u1ec3u di\u1ec5n nh\u1eefng con s\u1ed1 r\u1ea5t l\u1edbn ho\u1eb7c r\u1ea5t nh\u1ecf. VD: ch\u00fang ta c\u00f3 1 con s\u1ed1 r\u1ea5t l\u1edbn l\u00e0 20 t\u1ec9, 20 t\u1ec9 l\u00e0 m\u1ed9t con s\u1ed1 c\u00f3 10 s\u1ed1 0. Thay v\u00ec vi\u1ebft l\u00e0 <strong>20,000,000,000<\/strong> th\u00ec Excel s\u1ebd bi\u1ec3u di\u1ec5n con s\u1ed1 n\u00e0y d\u01b0\u1edbi d\u1ea1ng <strong>2E+10<\/strong>. Ngo\u00e0i c\u00e1ch \u0111\u1ecdc l\u00e0 20 t\u1ec9, th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u1ecdc con s\u1ed1 n\u00e0y l\u00e0 2 nh\u00e2n 10 m\u0169 10.<br \/>\nL\u1ef1a ch\u1ecdn duy nh\u1ea5t trong ph\u1ea7n n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i l\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1eb1ng sau d\u1ea5u ph\u1ea9y.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-scientific-notation-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-550\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-scientific-notation-format.png\" alt=\"excel-scientific-notation-format\" width=\"541\" height=\"691\" title=\"excel-scientific-notation-format\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_du_lieu_kieu_chu\"><\/span>\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n n\u1ed9i dung 1 \u00f4 sang \u0111\u1ecbnh d\u1ea1ng Text, ch\u1ec9 c\u1ea7n ch\u1ecdn nh\u1eefng \u00f4 c\u1ea7n chuy\u1ec3n v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Text. M\u1eb7c \u0111\u1ecbnh trong Excel s\u1ebd c\u0103n l\u1ec1 tr\u00e1i cho n\u1ed9i dung Text.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_dac_biet_%E2%80%93_Special\"><\/span>\u0110\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t \u2013 Special:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi m\u1ed7i n\u01b0\u1edbc, l\u1ea1i c\u00f3 1 s\u1ed1 d\u00e3y s\u1ed1 \u0111\u1eb7c tr\u01b0ng nh\u01b0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, m\u00e3 s\u1ed1 b\u01b0u \u0111i\u1ec7n, s\u1ed1 b\u1ea3o hi\u1ec3m an sinh x\u00e3 h\u1ed9i. \u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c s\u1ed1 n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng m\u1ee5c Special<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-special-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-551\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-special-format.png\" alt=\"excel-special-format\" width=\"541\" height=\"471\" title=\"excel-special-format\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_cua_nguoi_dung_%E2%80%93_Custom\"><\/span>\u0110\u1ecbnh d\u1ea1ng c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u2013 Custom<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng Custom l\u00e0 1 ch\u1ee7 \u0111\u1ec1 ph\u1ee9c t\u1ea1p v\u00e0 s\u1ebd \u0111\u01b0\u1ee3c chia s\u1ebb trong m\u1ed9t b\u00e0i vi\u1ebft kh\u00e1c.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Mot_so_video_lien_quan_den_viec_su_dung_dinh_dang_du_lieu_trong_Excel\"><\/span>M\u1ed9t s\u1ed1 video lien quan \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/KcZ2ZDiFReM\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><span style=\"font-family: georgia, palatino, serif\"><br \/>\n<\/span><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel:<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p><strong>Xem th\u00eam:<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html\"> C\u00e1ch ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/a> b\u1ea1n n\u00ean bi\u1ebft<\/strong><\/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=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">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\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">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\/2024\/12\/ex101_92019-nho-588.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6580,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6579","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\/6579","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=6579"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6579\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6580"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}