{"id":494272,"date":"2025-10-07T09:45:07","date_gmt":"2025-10-07T02:45:07","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=494272"},"modified":"2025-10-07T09:45:07","modified_gmt":"2025-10-07T02:45:07","slug":"dinh-dang-so-trong-excel-2","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/dinh-dang-so-trong-excel-2\/","title":{"rendered":"C\u00e1c lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel v\u00e0 c\u00e1ch thi\u1ebft l\u1eadp nhanh ch\u00f3ng"},"content":{"rendered":"

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. Thay v\u00ec hi\u1ec3n th\u1ecb con s\u1ed1 d\u01b0\u1edbi d\u1ea1ng th\u00f4, Excel cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i sang nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau nh\u01b0 ti\u1ec1n t\u1ec7, ph\u1ea7n tr\u0103m, ng\u00e0y th\u00e1ng ho\u1eb7c s\u1ed1 th\u1eadp ph\u00e2n. Vi\u1ec7c n\u00e0y kh\u00f4ng ch\u1ec9 mang l\u1ea1i t\u00ednh th\u1ea9m m\u1ef9 m\u00e0 c\u00f2n gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean r\u00f5 r\u00e0ng, ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 \u0111\u1ecdc. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1c lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ph\u1ed5 bi\u1ebfn trong Excel v\u00e0 c\u00e1ch thi\u1ebft l\u1eadp nhanh ch\u00f3ng.\u00a0<\/span><\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 (Number Formats) trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 (Number Formats) trong Excel l\u00e0 c\u00e1c quy t\u1eafc hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 tr\u00ean b\u1ea3ng t\u00ednh. Thay v\u00ec ch\u1ec9 hi\u1ec3n th\u1ecb s\u1ed1 nguy\u00ean ho\u1eb7c s\u1ed1 th\u1eadp ph\u00e2n th\u00f4ng th\u01b0\u1eddng, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng. V\u00ed d\u1ee5, m\u1ed9t con s\u1ed1 c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng ti\u1ec1n t\u1ec7 (\u20ab, $, \u20ac), ph\u1ea7n tr\u0103m (%), ho\u1eb7c d\u1ea1ng ng\u00e0y th\u00e1ng. Excel cung c\u1ea5p s\u1eb5n nhi\u1ec1u ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong th\u1ebb Home > Number, \u0111\u1ed3ng th\u1eddi cho ph\u00e9p t\u00f9y ch\u1ec9nh linh ho\u1ea1t \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u tr\u1ef1c quan v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n.\u00a0<\/span><\/p>\n

\"dinh-dang-so-trong-excel-2\"<\/picture><\/p>\n

Khi n\u00e0o c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1?<\/span><\/h2>\n

Vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel c\u1ea7n thi\u1ebft trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng nh\u1eb1m \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u d\u1ec5 \u0111\u1ecdc, ch\u00ednh x\u00e1c v\u00e0 ph\u1ea3n \u00e1nh \u0111\u00fang b\u1ea3n ch\u1ea5t th\u00f4ng tin. Tr\u01b0\u1edbc h\u1ebft, trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n ho\u1eb7c t\u00e0i ch\u00ednh, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Currency ho\u1eb7c Accounting \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 li\u1ec7u d\u01b0\u1edbi d\u1ea1ng ti\u1ec1n t\u1ec7, gi\u00fap b\u00e1o c\u00e1o r\u00f5 r\u00e0ng v\u00e0 tr\u00e1nh nh\u1ea7m l\u1eabn. Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh t\u1ef7 l\u1ec7, \u0111\u1ecbnh d\u1ea1ng Percentage tr\u1edf n\u00ean h\u1eefu \u00edch, v\u00ec n\u00f3 th\u1ec3 hi\u1ec7n ngay con s\u1ed1 d\u01b0\u1edbi d\u1ea1ng ph\u1ea7n tr\u0103m thay v\u00ec bu\u1ed9c ph\u1ea3i nh\u00e2n chia th\u1ee7 c\u00f4ng.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-3\"<\/picture><\/p>\n

Ngo\u00e0i ra, v\u1edbi d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u1eddi gian, \u0111\u1ecbnh d\u1ea1ng Date ho\u1eb7c Time l\u00e0 l\u1ef1a ch\u1ecdn kh\u00f4ng th\u1ec3 thi\u1ebfu, gi\u00fap hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng ho\u1eb7c gi\u1edd ph\u00fat ch\u00ednh x\u00e1c v\u00e0 \u0111\u1ed3ng b\u1ed9. Trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f2n gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng ph\u00e2n bi\u1ec7t gi\u1eefa c\u00e1c lo\u1ea1i th\u00f4ng tin: s\u1ed1 nguy\u00ean, s\u1ed1 th\u1eadp ph\u00e2n hay s\u1ed1 \u00e2m. Kh\u00f4ng ch\u1ec9 ph\u1ee5c v\u1ee5 t\u00ednh th\u1ea9m m\u1ef9, \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f2n h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n, b\u00e1o c\u00e1o v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch khoa h\u1ecdc. Nh\u1edd \u0111\u00f3, c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p, hi\u1ec7u qu\u1ea3 v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n.<\/span><\/p>\n

C\u00e1ch thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/span><\/h2>\n

B\u01b0\u1edbc 1: V\u00e0o tab Home, t\u00ecm nh\u00f3m Number, sau \u0111\u00f3 nh\u1ea5p v\u00e0o tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng Number Format \u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p. Excel cung c\u1ea5p nhi\u1ec1u t\u00f9y ch\u1ecdn nh\u01b0 General, Number, Currency, Accounting, Date, Time, Percentage\u2026<\/span><\/p>\n

\"dinh-dang-so-trong-excel-4\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: N\u1ebfu mu\u1ed1n thao t\u00e1c nhanh, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ngay m\u1ed9t trong nh\u1eefng \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb s\u1eb5n b\u00ean d\u01b0\u1edbi tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng. \u0110\u00e2y l\u00e0 c\u00e1ch ti\u1ec7n l\u1ee3i gi\u00fap thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1ec9 v\u1edbi m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-5\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: \u1ede v\u00ed d\u1ee5 minh h\u1ecda, khi mu\u1ed1n th\u00eam k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh $ v\u00e0 ch\u1ecdn \u0111\u01a1n v\u1ecb mong mu\u1ed1n, ch\u1eb3ng h\u1ea1n nh\u01b0 Dollar (Anh\/M\u1ef9). Ngay l\u1eadp t\u1ee9c, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u s\u1ed1 trong b\u1ea3ng t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb v\u1edbi k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 \u0111\u00e3 ch\u1ecdn.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-6\"<\/picture><\/p>\n

C\u00e1c d\u1ea1ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/span><\/h2>\n

Trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00e1c nhau, gi\u00fap hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 qu\u1ea3n l\u00fd h\u01a1n. Tuy nhi\u00ean, trong ph\u1ea1m vi b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb \u0111\u1ebfn b\u1ea1n nh\u1eefng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u01a1 b\u1ea3n v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong th\u1ef1c t\u1ebf, bao g\u1ed3m: \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u01b0\u1eddng, s\u1ed1 0, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, d\u1ea5u ch\u1ea5m, ti\u1ec1n t\u1ec7 v\u00e0 s\u1ed1 \u00e2m.\u00a0<\/span><\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel\u00a0<\/span><\/h3>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 trong ph\u1ea7n m\u1ec1m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn khi b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u1edf d\u1ea1ng s\u1ed1 h\u1ecdc c\u01a1 b\u1ea3n. T\u00ednh n\u0103ng n\u00e0y cho ph\u00e9p th\u00eam d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn, t\u00f9y ch\u1ec9nh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u g\u1ecdn g\u00e0ng, khoa h\u1ecdc.<\/span><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-7\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng b\u00f4i \u0111en, ch\u1ecdn Format Cells.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-8\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 Format Cells, nh\u1ea5n v\u00e0o tab Number, sau \u0111\u00f3 t\u00edch v\u00e0o \u00f4 Use 1000 Separator (,) \u0111\u1ec3 th\u00eam d\u1ea5u ph\u1ea9y ph\u00e2n c\u00e1ch sau m\u1ed7i ba ch\u1eef s\u1ed1.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-9\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: Nh\u1ea5n OK \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/span><\/p>\n

V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n nh\u1eadp s\u1ed1 1000000, sau khi \u0111\u1ecbnh d\u1ea1ng s\u1ebd hi\u1ec3n th\u1ecb th\u00e0nh 1,000,000. \u0110i\u1ec1u n\u00e0y gi\u00fap ng\u01b0\u1eddi xem d\u1ec5 d\u00e0ng theo d\u00f5i v\u00e0 ph\u00e2n bi\u1ec7t c\u00e1c con s\u1ed1 l\u1edbn. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh s\u1ed1 th\u1eadp ph\u00e2n hi\u1ec3n th\u1ecb, r\u1ea5t h\u1eefu \u00edch khi l\u00e0m b\u00e1o c\u00e1o t\u00e0i ch\u00ednh ho\u1eb7c t\u00ednh to\u00e1n c\u00f3 nhi\u1ec1u ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y. \u0110\u00e2y l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n nh\u1ea5t v\u00e0 th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c d\u00f9ng trong Excel.<\/span><\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 0 trong Excel\u00a0<\/span><\/h3>\n

Khi nh\u1eadp d\u1eef li\u1ec7u nh\u01b0 m\u00e3 b\u01b0u \u0111i\u1ec7n, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c m\u00e3 s\u1ea3n ph\u1ea9m, nhi\u1ec1u ng\u01b0\u1eddi g\u1eb7p t\u00ecnh tr\u1ea1ng s\u1ed1 0 \u1edf \u0111\u1ea7u b\u1ecb Excel t\u1ef1 \u0111\u1ed9ng x\u00f3a. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel.<\/span><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a s\u1ed1 c\u1ea7n ch\u1ec9nh.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-10\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5n chu\u1ed9t ph\u1ea3i, ch\u1ecdn Format Cells.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-11\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Trong tab Number, ch\u1ecdn Custom trong m\u1ee5c Category.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-12\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: \u1ede \u00f4 Type, nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 s\u1ed1 mong mu\u1ed1n. V\u00ed d\u1ee5: nh\u1eadp \u201c00000\u201d n\u1ebfu mu\u1ed1n t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb 5 ch\u1eef s\u1ed1, bao g\u1ed3m c\u1ea3 s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-13\"<\/picture><\/p>\n

B\u01b0\u1edbc 5: Nh\u1ea5n OK \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/span><\/p>\n

V\u00ed d\u1ee5: n\u1ebfu nh\u1eadp \u201c0123\u201d, Excel s\u1ebd hi\u1ec3n th\u1ecb \u201c00123\u201d v\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u0103m ch\u1eef s\u1ed1. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch cho c\u00e1c b\u1ea3ng qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u00e3 \u0111\u1ecbnh danh, n\u01a1i vi\u1ec7c gi\u1eef nguy\u00ean s\u1ed1 0 \u1edf \u0111\u1ea7u l\u00e0 r\u1ea5t quan tr\u1ecdng. Ng\u01b0\u1eddi d\u00f9ng n\u00ean l\u01b0u \u00fd s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 0 nh\u1eadp v\u00e0o \u00f4 Type s\u1ebd quy\u1ebft \u0111\u1ecbnh t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 hi\u1ec3n th\u1ecb trong \u00f4 d\u1eef li\u1ec7u.<\/span><\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel<\/span>\u00a0<\/span><\/h3>\n

S\u1ed1 \u0111i\u1ec7n tho\u1ea1i th\u01b0\u1eddng ch\u1ee9a nhi\u1ec1u ch\u1eef s\u1ed1 v\u00e0 b\u1eaft \u0111\u1ea7u b\u1eb1ng s\u1ed1 0, v\u00ec v\u1eady n\u1ebfu kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel \u0111\u00fang, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng lo\u1ea1i b\u1ecf s\u1ed1 0 \u1edf \u0111\u1ea7u ho\u1eb7c bi\u1ebfn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i th\u00e0nh d\u1ea1ng s\u1ed1 h\u1ecdc. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u1edf d\u1ea1ng v\u0103n b\u1ea3n.<\/span><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i.<\/span><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn Format Cells.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-14\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 Format Cells, ch\u1ecdn Text v\u00e0 nh\u1ea5n OK.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-15\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: Nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o \u00f4, Excel s\u1ebd gi\u1eef nguy\u00ean \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng b\u1ea1n g\u00f5, k\u1ec3 c\u1ea3 s\u1ed1 0 \u1edf \u0111\u1ea7u.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-16\"<\/picture><\/p>\n

V\u00ed d\u1ee5: khi nh\u1eadp \u201c0987654321\u201d, d\u1eef li\u1ec7u v\u1eabn hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c nh\u01b0 v\u1eady, thay v\u00ec m\u1ea5t s\u1ed1 0 v\u00e0 bi\u1ebfn th\u00e0nh \u201c987654321\u201d. C\u00e1ch n\u00e0y c\u0169ng h\u1eefu \u00edch khi b\u1ea1n nh\u1eadp c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0 m\u00e3 b\u01b0u \u0111i\u1ec7n, m\u00e3 kh\u00e1ch h\u00e0ng, ho\u1eb7c d\u00e3y s\u1ed1 c\u00f3 c\u1ea5u tr\u00fac c\u1ed1 \u0111\u1ecbnh. \u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n gi\u00fap b\u1ea3o to\u00e0n d\u1eef li\u1ec7u, tr\u00e1nh t\u00ecnh tr\u1ea1ng Excel t\u1ef1 \u0111\u1ed9ng x\u1eed l\u00fd sai.<\/span><\/p>\n

C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel b\u1eb1ng d\u1ea5u ch\u1ea5m\u00a0<\/span><\/h3>\n

Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n ph\u00e2n t\u00e1ch c\u00e1c con s\u1ed1 b\u1eb1ng d\u1ea5u ch\u1ea5m thay v\u00ec d\u1ea5u ph\u1ea9y, ch\u1eb3ng h\u1ea1n khi nh\u1eadp m\u00e3 s\u1ed1 ho\u1eb7c d\u00e3y s\u1ed1 d\u00e0i. \u0110\u00e2y l\u00e0 c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 theo d\u1ea1ng chu\u1ed7i v\u0103n b\u1ea3n, gi\u00fap d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb \u0111\u00fang mong mu\u1ed1n.<\/span><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-17\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Trong tab Number, ch\u1ecdn Text \u0111\u1ec3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c coi l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-18\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: Khi nh\u1eadp s\u1ed1, b\u1ea1n th\u00eam d\u1ea5u ch\u1ea5m \u201c.\u201d v\u00e0o c\u00e1c v\u1ecb tr\u00ed c\u1ea7n thi\u1ebft.<\/span><\/p>\n

V\u00ed d\u1ee5: nh\u1eadp \u201c123.456.789\u201d \u0111\u1ec3 th\u1ec3 hi\u1ec7n m\u1ed9t d\u00e3y s\u1ed1 c\u00f3 d\u1ea5u ch\u1ea5m ph\u00e2n t\u00e1ch. Excel s\u1ebd gi\u1eef nguy\u00ean c\u00e1ch hi\u1ec3n th\u1ecb n\u00e0y thay v\u00ec t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1. \u0110\u1ecbnh d\u1ea1ng n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n nh\u1eadp m\u00e3 \u0111\u1ecbnh danh, s\u1ed1 seri s\u1ea3n ph\u1ea9m ho\u1eb7c d\u1eef li\u1ec7u c\u1ea7n ph\u00e2n c\u00e1ch b\u1eb1ng d\u1ea5u ch\u1ea5m \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc.<\/span><\/p>\n

\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 trong Excel\u00a0<\/span><\/h3>\n

\u0110\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 (Currency) l\u00e0 m\u1ed9t trong nh\u1eefng ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel ph\u1ed5 bi\u1ebfn nh\u1ea5t, \u0111\u1eb7c bi\u1ec7t trong b\u00e1o c\u00e1o t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n hay kinh doanh. N\u00f3 gi\u00fap hi\u1ec3n th\u1ecb r\u00f5 r\u00e0ng gi\u00e1 tr\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi \u0111\u01a1n v\u1ecb ph\u00f9 h\u1ee3p.<\/span><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-19\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o tab Home, nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng ti\u1ec1n t\u1ec7 ($).<\/span><\/p>\n

\"dinh-dang-so-trong-excel-20\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Ch\u1ecdn \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 mong mu\u1ed1n, v\u00ed d\u1ee5 Dollar (USD), Euro (EUR), ho\u1eb7c Vi\u1ec7t Nam \u0111\u1ed3ng (VND).<\/span><\/p>\n

V\u00ed d\u1ee5: n\u1ebfu nh\u1eadp \u201c1000000\u201d v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 USD, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb \u201c$1,000,000.00\u201d. V\u1edbi \u0111\u01a1n v\u1ecb VND, d\u1eef li\u1ec7u s\u1ebd hi\u1ec3n th\u1ecb th\u00e0nh \u201c1,000,000 \u20ab\u201d. Excel c\u0169ng cho ph\u00e9p t\u00f9y ch\u1ec9nh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n hi\u1ec3n th\u1ecb sau d\u1ea5u ch\u1ea5m, gi\u00fap b\u1ea3ng t\u00ednh tr\u1edf n\u00ean r\u00f5 r\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. \u0110\u00e2y l\u00e0 \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng th\u1ec3 thi\u1ebfu trong m\u1ecdi b\u1ea3ng t\u00ednh c\u00f3 li\u00ean quan \u0111\u1ebfn giao d\u1ecbch ho\u1eb7c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh.<\/span><\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m trong Excel\u00a0<\/span><\/h3>\n

S\u1ed1 \u00e2m \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel m\u1eb7c \u0111\u1ecbnh hi\u1ec3n th\u1ecb v\u1edbi d\u1ea5u \u201c-\u201d tr\u01b0\u1edbc s\u1ed1, nh\u01b0ng nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n bi\u1ec3u th\u1ecb ch\u00fang d\u01b0\u1edbi d\u1ea1ng \u0111\u1eb7c bi\u1ec7t, v\u00ed d\u1ee5 \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c \u0111\u1ec3 d\u1ec5 ph\u00e2n bi\u1ec7t. Excel cho ph\u00e9p \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m b\u1eb1ng t\u00f9y ch\u1ec9nh.<\/span><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a s\u1ed1 \u00e2m.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-21\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn Format Cells.<\/span><\/p>\n

B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 Format Cells, ch\u1ecdn tab Number \u2192 m\u1ee5c Custom.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-22\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: \u1ede \u00f4 Type, nh\u1eadp \u0111\u1ecbnh d\u1ea1ng: #,##0_);(#,##0) v\u00e0 nh\u1ea5n OK.<\/span><\/p>\n

\"dinh-dang-so-trong-excel-23\"<\/picture><\/p>\n

K\u1ebft qu\u1ea3: c\u00e1c s\u1ed1 d\u01b0\u01a1ng hi\u1ec3n th\u1ecb b\u00ecnh th\u01b0\u1eddng, trong khi s\u1ed1 \u00e2m s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c, v\u00ed d\u1ee5 \u201c(1,000)\u201d thay cho \u201c-1000\u201d. C\u00e1ch \u0111\u1ecbnh d\u1ea1ng n\u00e0y gi\u00fap b\u1ea3ng s\u1ed1 li\u1ec7u tr\u1ef1c quan h\u01a1n, \u0111\u1eb7c bi\u1ec7t trong k\u1ebf to\u00e1n, n\u01a1i vi\u1ec7c ph\u00e2n bi\u1ec7t gi\u1eefa s\u1ed1 d\u01b0\u01a1ng v\u00e0 s\u1ed1 \u00e2m v\u00f4 c\u00f9ng quan tr\u1ecdng. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh m\u00e0u s\u1eafc \u0111\u1ec3 s\u1ed1 \u00e2m hi\u1ec3n th\u1ecb b\u1eb1ng m\u00e0u \u0111\u1ecf, t\u0103ng kh\u1ea3 n\u0103ng nh\u1eadn di\u1ec7n d\u1eef li\u1ec7u.<\/span><\/p>\n

L\u01b0u \u00fd khi s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/span><\/h2>\n