การจัดรูปแบบเซลล์ใน Custom ให้มีสีใน Excel

<p> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"><a class="tooltip-target" data-citationid="544406ce-fa58-03cc-aa58-d68aba95ad4e-2-group" href="https://support.microsoft.com/th-th/office/%E0%B9%83%E0%B8%8A%E0%B9%89%E0%B9%81%E0%B8%96%E0%B8%9A%E0%B8%82%E0%B9%89%E0%B8%AD%E0%B8%A1%E0%B8%B9%E0%B8%A5-%E0%B8%A3%E0%B8%B0%E0%B8%94%E0%B8%B1%E0%B8%9A%E0%B8%AA%E0%B8%B5-%E0%B9%81%E0%B8%A5%E0%B8%B0%E0%B8%8A%E0%B8%B8%E0%B8%94%E0%B9%84%E0%B8%AD%E0%B8%84%E0%B8%AD%E0%B8%99%E0%B9%80%E0%B8%9E%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B9%80%E0%B8%99%E0%B9%89%E0%B8%99%E0%B8%82%E0%B9%89%E0%B8%AD%E0%B8%A1%E0%B8%B9%E0%B8%A5-f118d0a6-5921-4e2e-905b-fe00f3378fb9" style="border-bottom: 2px solid transparent; color: inherit; position: relative; text-decoration-color: var(--cib-color-neutral-foreground-hint-light); text-decoration-line: underline; text-decoration-style: dotted; text-decoration-thickness: initial; text-underline-offset: 3px;" target="_blank">หากต้องการจัดรูปแบบตัวเลขให้มีสีหรือเงื่อนไข คุณสามารถใช้ custom format และใส่โค้ดสีหรือเงื่อนไขได้</a> <span> </span>วิธีการคือ</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>เลือกเซลล์ที่ต้องการจัดรูปแบบ</li><li>คลิกขวาแล้วเลือก Format Cells</li><li>เลือกแท็บ Number แล้วเลือกประเภท Custom</li><li>ในช่อง Type ให้พิมพ์โค้ดรูปแบบตัวเลขที่ต้องการ เช่น [Red]0.00;[Blue]-0.00;[Green]0</li><li>คลิก OK</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โค้ดสีที่ใช้ใน custom format มีดังนี้</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>[BLACK], [BLUE], [CYAN], [GREEN], [MAGENTA], [RED], [WHITE], [YELLOW]</li><li>[COLOR 1-56] เป็นสีที่กำหนดจาก Theme Color</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โค้ดเงื่อนไขที่ใช้ใน custom format มีดังนี้</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>; (เครื่องหมายอัญประกาศ) ใช้แยกส่วนของ custom format เป็นสี่ส่วน คือ positive;negative;zero;text</li><li>[] (วงเล็บเหลี่ยม) ใช้กำหนดเงื่อนไขที่ต้องการ เช่น [<100]0.00;[>=100]0.0</li><li>? (เครื่องหมายคำถาม) ใช้แทนตำแหน่งของตัวเลขที่ไม่จำเป็นต้องแสดง เช่น ??.??;???.??</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ตัวอย่างการใช้ custom format เพื่อจัดรูปแบบตัวเลขตามสีหรือเงื่อนไข</p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">ตัวเลข</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Custom Format</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Result</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">12.34</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Red color with 12.34</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">-12.34</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Blue color with -12.34</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Green color with 0</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">ABC</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[Red]0.00;[Blue]-0.00;[Green]0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">No color with ABC</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">99</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[<100]0.00;[>=100]0.0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Two decimal places with 99.00</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">100</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">[<100]0.00;[>=100]0.0</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">One decimal place with 100.0</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">-5</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">??.??;???.??</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Two spaces before -5</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">-50</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">??.??;???.??</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">One space before -50</td></tr></tbody></table><p> </p>

การจัดรูปแบบเซลล์ใน Custom ให้มีสีใน Excel

  หากต้องการจัดรูปแบบตัวเลขให้มีสีหรือเงื่อนไข คุณสามารถใช้ custom format และใส่โค้ดสีหรือเงื่อนไขได้   วิธีการคือ เลือกเซลล์ที่ต้องการจัดร...

อ่านเพิ่มเติม »

การใส่เลข 0 หน้าตัวเลขใน Excel

<p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">วิธีหนึ่งในการเติมเลข 0 หน้าตัวเลขใน excel คือ<a class="tooltip-target" data-citationid="b06bbacf-d3ab-26cc-e07a-4c2bb63b8c85-4-group" href="https://support.microsoft.com/th-th/office/%E0%B8%AA%E0%B8%A3%E0%B9%89%E0%B8%B2%E0%B8%87%E0%B9%81%E0%B8%A5%E0%B8%B0%E0%B8%9B%E0%B8%A3%E0%B8%B1%E0%B8%9A%E0%B9%83%E0%B8%8A%E0%B9%89%E0%B8%A3%E0%B8%B9%E0%B8%9B%E0%B9%81%E0%B8%9A%E0%B8%9A%E0%B8%95%E0%B8%B1%E0%B8%A7%E0%B9%80%E0%B8%A5%E0%B8%82%E0%B9%81%E0%B8%9A%E0%B8%9A%E0%B8%9B%E0%B8%A3%E0%B8%B1%E0%B8%9A%E0%B9%81%E0%B8%95%E0%B9%88%E0%B8%87%E0%B9%80%E0%B8%AD%E0%B8%87-6c308025-35da-4047-9481-c146a12063df" style="border-bottom: 2px solid transparent; color: inherit; position: relative; text-decoration-color: var(--cib-color-neutral-foreground-hint-light); text-decoration-line: underline; text-decoration-style: dotted; text-decoration-thickness: initial; text-underline-offset: 3px;" target="_blank">การเปลี่ยนรูปแบบของตัวเลขให้เป็น custom ใน excel ซึ่งก็คือการกำหนดรูปแบบตัวเลขที่ไม่มีให้เลือกในรูปแบบมาตรฐาน โดยใช้โค้ดรูปแบบตัวเลขที่มีความหมายต่างกัน เช่น</a></p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>0 แสดงตัวเลขออกมาเสมอ ถ้าไม่มีจะเติมศูนย์</li><li><h1 style="font-size: var(--cib-type-title2-font-size); font-variation-settings: var(--cib-type-title2-font-variation-settings); font-weight: var(--cib-type-title2-font-weight); line-height: var(--cib-type-title2-line-height); margin: 0px; padding: 0px; user-select: text; word-break: break-word;">แสดงตัวเลขออกมาเฉพาะที่จำเป็น ถ้าไม่มีจะไม่แสดง</h1></li><li>. แสดงจุดทศนิยม</li><li>, แสดงเครื่องหมายคอมม่า</li><li>% แสดงเปอร์เซ็นต์</li><li>E+ E- e+ e- แสดงในรูปแบบเลขยกกำลัง</li><li>\ ใช้ escape character เพื่อแสดงตัวอักษรพิเศษ</li><li>“text” ใช้เพื่อแสดงข้อความที่กำหนด</li><li>[ ] ใช้เพื่อกำหนดสีหรือเงื่อนไข</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ตัวอย่างการใช้โค้ดรูปแบบตัวเลข</p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">โค้ด</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">ผลลัพธ์</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">คำอธิบาย</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#,##0.00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">1,234.57</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มจุดทศนิยมสองตำแหน่งและคอมม่า</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#,##0.00;[Red]-#,##0.00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">-1,234.57</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มสีแดงให้กับค่าลบ</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#,##0.00_);(#,##0.00)</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">(1,234.57)</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มวงเล็บให้กับค่าลบ</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">0%</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">10%</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มเครื่องหมาย %</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;"># ?/?</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">1 2/3</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มเศษส่วน</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">#.00E+00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">1.23E+03</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มรูปแบบเลขยกกำลัง</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">* #,##0 *</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">* 1,234 *</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่ม * ทั้งสองข้าง</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">"Total "0.00</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Total 1234.57</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">เพิ่มข้อความ Total</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;"> </td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;"> </td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;"> </td></tr></tbody></table><p> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">หากต้องการเติมเลข 0 ลงข้างหน้าตัวเลขเบอร์โทรศัพท์ เราสามารถใช้ custom format ใน excel ได้<span> </span>วิธีการคือ</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>เลือกเซลล์ที่ต้องการจัดรูปแบบ</li><li>คลิกขวาแล้วเลือก Format Cells</li><li>เลือกแท็บ Number แล้วเลือกประเภท Custom</li><li>ในช่อง Type ให้พิมพ์โค้ดรูปแบบตัวเลขที่ต้องการ เช่น 0000000000</li><li>คลิก OK</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โค้ดรูปแบบตัวเลขที่ใช้ใน custom format จะมีหลักการดังนี้</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>0 แสดงตัวเลขออกมาเสมอ ถ้าไม่มีจะเติมศูนย์</li><li><h1 style="font-size: var(--cib-type-title2-font-size); font-variation-settings: var(--cib-type-title2-font-variation-settings); font-weight: var(--cib-type-title2-font-weight); line-height: var(--cib-type-title2-line-height); margin: 0px; padding: 0px; user-select: text; word-break: break-word;">แสดงตัวเลขออกมาเฉพาะที่จำเป็น ถ้าไม่มีจะไม่แสดง</h1></li><li>\ ใช้ escape character เพื่อแสดงตัวอักษรพิเศษ เช่น -</li><li>“text” ใช้เพื่อแสดงข้อความที่กำหนด</li></ul><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ตัวอย่างการใช้ custom format เพื่อจัดรูปแบบเบอร์โทรศัพท์</p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">เบอร์โทร</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Custom Format</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Result</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">1234567890</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">(000)000-0000</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">(123)456-7890</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">1234567890</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">"Tel."0000-0000</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Tel.1234-5678</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">1234567890</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">“Call” # ### ###</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Call 1 234 567</td></tr></tbody></table>

การใส่เลข 0 หน้าตัวเลขใน Excel

วิธีหนึ่งในการเติมเลข 0 หน้าตัวเลขใน excel คือ การเปลี่ยนรูปแบบของตัวเลขให้เป็น custom ใน excel ซึ่งก็คือการกำหนดรูปแบบตัวเลขที่ไม่มีให้เลือ...

อ่านเพิ่มเติม »

ฟังก์ชั่น Select ใน AppSheet

<p> </p><p>                                                   <b>  ฟังก์ชั่น SELECT</b> </p><p> </p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 1.25em; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">ฟังก์ชั่น SELECT ใน AppSheet เป็นฟังก์ชั่นที่ใช้สำหรับกรองข้อมูลในตารางหรือวิวที่สร้างขึ้นในแอปพลิเคชัน ฟังก์ชั่นนี้ช่วยให้ผู้ใช้งานสามารถเลือกแสดงเฉพาะข้อมูลที่ต้องการเท่านั้น โดยใช้เงื่อนไขหรือเปรียบเทียบค่าในแต่ละคอลัมน์</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">รูปแบบของฟังก์ชั่น SELECT จะเป็นดังนี้:</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">SELECT(Table[Column], Condition)</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">โดย Table คือชื่อตารางที่ต้องการกรองข้อมูล และ Column คือชื่อคอลัมน์ที่ต้องการกรองข้อมูล ส่วน Condition คือเงื่อนไขการกรองข้อมูล ซึ่งสามารถใช้ตัวดำเนินการต่างๆ เช่น =, <, >, <=, >=, <> และ AND, OR ได้</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">ตัวอย่างการใช้งาน SELECT ใน AppSheet เพื่อกรองข้อมูลในตาราง:</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">SELECT(Orders[Customer Name], [Order Date] > "2022-01-01")</p><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">ซึ่งจะกรองแสดงเฉพาะชื่อลูกค้าในตาราง Orders ที่มีวันที่สั่งซื้อหลังจาก 2022-01-01 เท่านั้น</p><p> </p><br /><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;"> </p><div class="separator" style="clear: both; text-align: center;"><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPVccUYsbckDZwiFmn9ZrPlsAD3KRQx3PeGwe6lEQNGtNIGNNM6Glrdb6kdak7HbknkPb297jiyiydPX5GmsnieXuUnqA1PCzxOgT_YaMx9F5NFalrWq19a6M7woo8d9way0hB50Ai77SfyXX5M7hc3Yz_q49LZU8mB7HVcBHUaaTGlILrmla7fWnxOQ/s550/appsheet1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"> </a></div><div class="separator" style="clear: both; text-align: center;"> </div><br /><p></p><br /><p style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border: 0px solid rgb(217, 217, 227); box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 1.25em 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;"> </p><p> </p>

ฟังก์ชั่น Select ใน AppSheet

                                                        ฟังก์ชั่น SELECT   ฟังก์ชั่น SELECT ใน AppSheet เป็นฟังก์ชั่นที่ใช้สำหรับกรองข้อมูล...

อ่านเพิ่มเติม »

การใช้ Flash Fill ใน Excel

<p> </p><h2 style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; padding: 0px; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; word-break: break-word; word-spacing: 0px;">                                                          การใช้ Flash Fill ใน Excel<br /></h2><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; margin: 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">Flash Fill ใน Excel เป็นเครื่องมือที่ช่วยให้คุณสามารถตัด ต่อ แปลง หรือจัดรูปแบบข้อมูลในเซลล์ได้อย่างอัตโนมัติ โดยไม่ต้องเขียนสูตร หลักการทำงานของ Flash Fill คือ Excel จะพยายามหารูปแบบ (Pattern) จากข้อมูลที่คุณใส่เป็นตัวอย่าง เพื่อให้ได้ผลลัพธ์ที่คุณต้องการ<a aria-label="งานเสร็จฉับไว ด้วย Flash Fill - เทพเอ็กเซล : Thep Excel" class="ac-anchor sup-target" data-citationid="d47b102c-09b2-4404-9573-b2f31b38fa87-2" href="https://www.thepexcel.com/flash-fill-quick-win/" style="color: var(--cib-color-brand-link-foreground); position: relative; text-decoration: none;" target="_blank"><sup style="align-items: center; background: var(--cib-color-brand-tertiary-background); border-radius: 3px; color: var(--cib-color-brand-tertiary-foreground); display: inline-flex; font-size: 10px; font-weight: 600; height: 14px; justify-content: center; margin: 0px 2px; min-width: 14px; outline: transparent solid 1px; position: relative; text-decoration-color: transparent; top: -1px; vertical-align: top;">1</sup></a><a aria-label="How to Fill Excel Cells Automatically with Flash Fill and Auto Fill" class="ac-anchor sup-target" data-citationid="d47b102c-09b2-4404-9573-b2f31b38fa87-4" href="https://www.howtogeek.com/715978/how-to-fill-excel-cells-automatically-with-flash-fill-and-auto-fill/" style="color: var(--cib-color-brand-link-foreground); position: relative; text-decoration: none;" target="_blank"><sup style="align-items: center; background: var(--cib-color-brand-tertiary-background); border-radius: 3px; color: var(--cib-color-brand-tertiary-foreground); display: inline-flex; font-size: 10px; font-weight: 600; height: 14px; justify-content: center; margin: 0px 2px; min-width: 14px; outline: transparent solid 1px; position: relative; text-decoration-color: transparent; top: -1px; vertical-align: top;">2</sup></a>.</p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; margin: 10px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"><a class="tooltip-target" data-citationid="d47b102c-09b2-4404-9573-b2f31b38fa87-11-group" href="https://www.thepexcel.com/flash-fill-quick-win/" style="border-bottom: 2px solid transparent; color: inherit; position: relative; text-decoration-color: var(--cib-color-neutral-foreground-hint-light); text-decoration-line: underline; text-decoration-style: dotted; text-decoration-thickness: initial; text-underline-offset: 3px;" target="_blank">วิธีการใช้ Flash Fill ใน Excel มีดังนี้</a></p><ol style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>เตรียมข้อมูลดิบและคอลัมน์ผลลัพธ์ที่คุณต้องการได้</li><li>ใส่ตัวอย่างผลลัพธ์ที่คุณต้องการไปซัก 1-2 บรรทัด เพื่อทำการสอน Excel</li><li>คลิกที่เซลล์ที่เราสอน (หรือจะคลิกเซลล์ข้างใต้ก็ได้) แล้วกด Ctrl+E ทีละช่อง (ทีละคอลัมน์) เพื่อใช้ Flash Fill</li><li>ถ้า Excel ให้ผลลัพธ์ผิด ก็ต้องสอนเพิ่มไปอีกซักบรรทัดนึง เพื่อให้มันฉลาดขึ้น</li></ol><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; margin: 10px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">Flash Fill เป็นเครื่องมือที่มีประโยชน์และสะดวกมาก แต่มันก็มีข้อเสียบ้าง เช่น</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>Flash Fill ใช้ได้แค่ Excel 2013 ขึ้นไปเท่านั้น</li><li>Flash Fill เป็นการ Stamp ค่าคงที่ลงไปแล้ว ไม่ใช่สูตร ดังนั้นถ้าข้อมูลเปลี่ยนหรือมีข้อมูลใหม่มา ผลลัพธ์จะไม่เปลี่ยนตาม</li></ul><p> </p><p><span face="-apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif" style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: inline; float: none; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">ถ้าคุณต้องการสร้างอีเมล์จากชื่อและนามสกุล คุณสามารถใช้ Flash Fill ได้ดังนี้</span> <br /></p><ol style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>ใส่ตัวอย่างผลลัพธ์ที่คุณต้องการไปซัก 1-2 บรรทัด เช่น john.smith@email.com</li><li>คลิกที่เซลล์ที่เราสอน (หรือจะคลิกเซลล์ข้างใต้ก็ได้) แล้วกด Ctrl+E ทีละช่อง (ทีละคอลัมน์) เพื่อใช้ Flash Fill</li><li>Excel จะพยายามหารูปแบบ (Pattern) จากข้อมูลที่คุณใส่เป็นตัวอย่าง เพื่อให้ได้ผลลัพธ์ที่คุณต้องการ</li></ol><p>ตัวอย่าง </p><p> <br /></p><table style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); border-radius: 6px; border-spacing: 0px; border: 1px solid var(--cib-color-neutral-stroke); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 8px 0px; orphans: 2; overflow: hidden; padding: 0px 12px; table-layout: fixed; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-transform: none; white-space: normal; widows: 2; width: 736px; word-spacing: 0px;"><thead><tr style="padding: 0px 4px;"><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">ชื่อ</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">นามสกุล</th><th style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-strong-font-size); font-variation-settings: var(--cib-type-body1-strong-font-variation-settings); font-weight: 600; line-height: var(--cib-type-body1-strong-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">อีเมล์</th></tr></thead><tbody><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">John</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Smith</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">john.smith@email.com</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">Mary</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Jones</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">mary.jones@email.com</td></tr><tr style="padding: 0px 4px;"><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px 8px 0px; text-align: left; vertical-align: baseline; word-break: initial;">Peter</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">Lee</td><td style="color: var(--cib-color-neutral-foreground); font-size: var(--cib-type-body1-font-size); font-variation-settings: var(--cib-type-body1-font-variation-settings); font-weight: var(--cib-type-body1-font-weight); line-height: var(--cib-type-body1-line-height); padding: 8px 4px; text-align: left; vertical-align: baseline; word-break: initial;">peter.lee@email.com</td></tr></tbody></table><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; margin: 10px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">Flash Fill จะเติมข้อมูลให้คุณโดยอัตโนมัติ โดยไม่ต้องเขียนสูตร</p><p>ดูตัวอย่างการใช้งาน ได้ที่   </p><p></p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="395" src="https://www.youtube.com/embed/tPqQAYcYbZI" width="475" youtube-src-id="tPqQAYcYbZI"></iframe></div><br /> <p></p><p><br /></p><p> </p><p> <br /></p><p> </p>

การใช้ Flash Fill ใน Excel

                                                            การใช้ Flash Fill ใน Excel     Flash Fill ใน Excel เป็นเครื่องมือที่ช่วยให้คุณสา...

อ่านเพิ่มเติม »

การใช้คำสั่ง TextSplit ใน Excel

<p> </p><p>สูตร TEXTSPLIT ใน Excel เป็นฟังก์ชันที่ช่วยในการแยกข้อความออกเป็นคอลัมน์หรือแถวตามตัวคั่นที่กำหนด โดยใช้ฟังก์ชันนี้จะช่วยให้ผู้ใช้สามารถแยกข้อความออกเป็นคอลัมน์หรือแถวได้อย่างง่ายดาย โดยไม่ต้องใช้วิธีการแบ่งข้อความด้วยตัวเอง ซึ่งจะช่วยประหยัดเวลาและลดความผิดพลาดได้เป็นอย่างมา</p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">สูตรการใช้งาน TEXTSPLIT ใน Excel มีรูปแบบดังนี้:</p><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;"> </p><pre style="-webkit-text-stroke-width: 0px; background: rgba(0, 0, 0, 0.02); border-radius: 8px; border: 1px solid var(--cib-color-neutral-stroke); box-sizing: border-box; color: #111111; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 4px; orphans: 2; padding: 10px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px;"><code style="font-size: 14px; white-space: pre-wrap;">=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with]) </code></pre><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">โดยที่:</p><ul style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; display: flex; flex-direction: column; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; gap: 10px; letter-spacing: normal; margin: 0px; orphans: 2; padding-left: 24px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><li>text: เป็นข้อความที่ต้องการแยก</li><li>col_delimiter: เป็นตัวคั่นที่ใช้แยกข้อความเป็นคอลัมน์</li><li>row_delimiter: เป็นตัวคั่นที่ใช้แยกข้อความเป็นแถว</li><li>ignore_empty: เป็นการเลือกว่าจะไม่แสดงผลลัพธ์ที่เป็นช่องว่างหรือไม่ (TRUE/FALSE)</li><li>match_mode: เป็นการเลือกว่าจะให้การแยกข้อความเป็นตัวพิมพ์เล็กหรือตัวพิมพ์ใหญ่ (0/1)</li><li>pad_with: เป็นการเลือกว่าจะเติมช่องว่างหรือไม่ (TRUE/FALSE)</li></ul><p> ตัวอย่างการใช้งาน Textsplitที่ 1 <br /></p><pre style="-webkit-text-stroke-width: 0px; background: rgba(0, 0, 0, 0.02); border-radius: 8px; border: 1px solid var(--cib-color-neutral-stroke); box-sizing: border-box; color: #111111; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 4px; orphans: 2; padding: 10px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px;"><code style="font-size: 14px; white-space: pre-wrap;">=TEXTSPLIT("apple,banana,orange",",") </code></pre><p style="-webkit-text-stroke-width: 0px; background-color: rgba(255, 255, 255, 0.6); color: #111111; font-family: -apple-system, Roboto, SegoeUI, "Segoe UI", "Helvetica Neue", Helvetica, "Microsoft YaHei", "Meiryo UI", Meiryo, "Arial Unicode MS", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-variation-settings: var(--cib-type-body2-font-variation-settings); font-weight: 400; letter-spacing: normal; line-height: var(--cib-type-body2-line-height); margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 10px !important; orphans: 2; padding: 0px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; user-select: text; white-space: normal; widows: 2; word-break: break-word; word-spacing: 0px;">ผลลัพธ์ที่ได้คือ</p><pre style="-webkit-text-stroke-width: 0px; background: rgba(0, 0, 0, 0.02); border-radius: 8px; border: 1px solid var(--cib-color-neutral-stroke); box-sizing: border-box; color: #111111; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px 0px 4px; orphans: 2; padding: 10px; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px;"><code style="font-size: 14px; white-space: pre-wrap;">apple banana orange</code></pre><p></p><p>ตัวอย่างการใช้งาน Textsplit ที่ 2</p><p>=TEXTSPLIT(<span style="-webkit-text-stroke-width: 0px; background-color: #f7f7f8; color: #374151; display: inline !important; float: none; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;">A2:A4," ")</span></p><table style="--tw-border-spacing-x: 0px; --tw-border-spacing-y: 0px; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; -webkit-text-stroke-width: 0px; background-color: #f7f7f8; border-collapse: separate; border-color: inherit; border-image: initial; border-spacing: var(--tw-border-spacing-x) var(--tw-border-spacing-y); border-style: solid; border-width: 0px; box-sizing: border-box; color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 0.875em; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; line-height: 1.71429; margin-bottom: 0px; margin-top: 2em; orphans: 2; table-layout: auto; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; width: 460.994px; word-spacing: 0px;"><thead style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-th-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px 0px 1px; box-sizing: border-box;"><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border: 0px solid rgb(217, 217, 227); box-sizing: border-box;"><th style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; background-color: rgba(236, 236, 241, 0.2); border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-top-left-radius: 0.375rem; border-width: 1px 0px 1px 1px; box-sizing: border-box; color: var(--tw-prose-headings); font-weight: 600; padding: 0.25rem 0.75rem; vertical-align: bottom;">ชื่อ - นามสกุล</th><th style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; background-color: rgba(236, 236, 241, 0.2); border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 1px 0px 1px 1px; box-sizing: border-box; color: var(--tw-prose-headings); font-weight: 600; padding: 0.25rem 0.75rem; vertical-align: bottom;">First Name</th><th style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; background-color: rgba(236, 236, 241, 0.2); border-top-right-radius: 0.375rem; border: 1px solid rgb(217, 217, 227); box-sizing: border-box; color: var(--tw-prose-headings); font-weight: 600; padding: 0.25rem 0.75rem; vertical-align: bottom;">Last Name</th></tr></thead><tbody style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border: 0px solid rgb(217, 217, 227); box-sizing: border-box;"><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-td-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px 0px 1px; box-sizing: border-box;"><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">John Doe</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">John</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Doe</td></tr><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-td-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px 0px 1px; box-sizing: border-box;"><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jane Smith</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jane</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Smith</td></tr><tr style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-color: var(--tw-prose-td-borders); border-image: initial; border-left-color: rgb(217, 217, 227); border-right-color: rgb(217, 217, 227); border-style: solid; border-top-color: rgb(217, 217, 227); border-width: 0px; box-sizing: border-box;"><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-left-radius: 0.375rem; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jim Brown</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Jim</td><td style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-ring-color: rgba(59,130,246,0.5); --tw-ring-offset-color: #fff; --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-offset-width: 0px; --tw-ring-shadow: 0 0 transparent; --tw-rotate: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-scroll-snap-strictness: proximity; --tw-shadow-colored: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-skew-x: 0; --tw-skew-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; border-bottom-right-radius: 0.375rem; border-color: rgb(217, 217, 227); border-image: initial; border-style: solid; border-width: 0px 1px 1px; box-sizing: border-box; padding: 0.25rem 0.75rem; vertical-align: baseline;">Brown</td></tr></tbody></table><p></p><p><br /></p><p>ตัวอย่างการใช้งานอื่น ๆ ดูได้ที่ </p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="431" src="https://www.youtube.com/embed/U-fShUldU1A" width="518" youtube-src-id="U-fShUldU1A"></iframe></div><br /><p><br /></p><p><span style="-webkit-text-stroke-width: 0px; background-color: #f7f7f8; color: #374151; display: inline !important; float: none; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px;"> </span> <br /></p>

การใช้คำสั่ง TextSplit ใน Excel

  สูตร TEXTSPLIT ใน Excel เป็นฟังก์ชันที่ช่วยในการแยกข้อความออกเป็นคอลัมน์หรือแถวตามตัวคั่นที่กำหนด โดยใช้ฟังก์ชันนี้จะช่วยให้ผู้ใช้สามารถแย...

อ่านเพิ่มเติม »

วิธีจ่ายค่าประปาส่วนภูมิภาคเกินกำหนด

เนื่องจากเป็นคนขี้ลืมมาก ดังนั้นบ่อยครั้งที่ค่าน้ำประปาส่วนภูมิภาค เกินชำระล่าช้า มันจะไม่มีปัญหาแม้แต่น้อย ถ้าเกิดว่า การประปาส่วนภูมิภาคแห่งนี้ อยู่ใกล้บ้าน แต่ทว่าเมื่อต้องขับรถไปหลายกิโลเพื่อจะจ่ายค่าน้ำ มันก็เกิดเป็นปัญหาใหญ่ เพราะว่า<b>บาร์โค้ดที่สแกนในกรณีที่จ่ายช้า มันจ่ายไม่ได้</b> แต่ทว่าเนื่องจากสถานการณ์โควิด ทำให้โชคดีมาก ๆ ที่การประปาส่วนภูมิภาคช่วยแก้ปัญหานี้ให้กับผู้ใช้งาน <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPV_IhXG4fBSbCsUL1P_HYSd8Gw7SesioNx3V9vmdQokCMO_r3rsoKonKTt-lJYbFKXpEuAUxIkowXmLNUJrMS2Cpa8JxTt3cOjQDbOZGoG9Fur9BcsECL1BX0gpjlTwSdOg28ngj8ck9r/s1600/1645000012197794-1.png" style="margin-left: 1em; margin-right: 1em;"> <img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPV_IhXG4fBSbCsUL1P_HYSd8Gw7SesioNx3V9vmdQokCMO_r3rsoKonKTt-lJYbFKXpEuAUxIkowXmLNUJrMS2Cpa8JxTt3cOjQDbOZGoG9Fur9BcsECL1BX0gpjlTwSdOg28ngj8ck9r/s1600/1645000012197794-1.png" width="400" /> </a><br /></div>หากบิลชำระค่าน้ำ เกินกำหนด ก็เพียงสมัครเป็นเพื่อนทางไลน์ กับ การประปาส่วนภูมิภาค แล้วลงทะเบียนการใช้งาน<div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjkuanbGRgDhN86Pc56VX2NLeLRXi7xRE5Ak1_9C3Ia9z_Z0TREBZj8OIRgZncBJP8Azu2nBv0_2v0QNl4HM4WC8jiG5rAn4l_z-QIm4W84HePSWN3BPmH3T27NXzrCOxGjkErpv9PtxdXbp8i10gR47pXlivOcH4wnhADGE2-zJs0iyfLSqab5ySHZgA=s772" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="772" data-original-width="620" height="320" src="https://blogger.googleusercontent.com/img/a/AVvXsEjkuanbGRgDhN86Pc56VX2NLeLRXi7xRE5Ak1_9C3Ia9z_Z0TREBZj8OIRgZncBJP8Azu2nBv0_2v0QNl4HM4WC8jiG5rAn4l_z-QIm4W84HePSWN3BPmH3T27NXzrCOxGjkErpv9PtxdXbp8i10gR47pXlivOcH4wnhADGE2-zJs0iyfLSqab5ySHZgA=s320" width="257" /></a></div><br /><div><br /><div class="separator" style="clear: both; text-align: center;"> </div>โดยใช้เลขที่ผู้ใช้ในบิลการชำระเงิน เมื่อลงทะเบียนเสร็จ </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEj6TYEm1XliHhOXnai_TxxbbrMa45nSPnbmZMOOux22S7Wuwtaa4d3aMJPHv_E_iIsIGoaPePLob5ZEXTOAtIy_c8r2Zq_eQEWEDmggbWSljp-ZfKyh_cDeebKYGthjnrgdsl4J8NtrHDrSwdZgU5ua8vglLHETk-g56FaMU0ibveRjnTG6UeLY9CxtdA=s1902" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1902" data-original-width="945" height="320" src="https://blogger.googleusercontent.com/img/a/AVvXsEj6TYEm1XliHhOXnai_TxxbbrMa45nSPnbmZMOOux22S7Wuwtaa4d3aMJPHv_E_iIsIGoaPePLob5ZEXTOAtIy_c8r2Zq_eQEWEDmggbWSljp-ZfKyh_cDeebKYGthjnrgdsl4J8NtrHDrSwdZgU5ua8vglLHETk-g56FaMU0ibveRjnTG6UeLY9CxtdA=s320" width="159" /></a></div><br /><div><br /></div><div>ก็ขอบาร์โค้ดในการชำระเงินล่าช้า ที่เมนู ตรวจสอบค่าน้ำ/ชำระค่าน้ำ </div><div> เพียงเท่านี้ก็สามารถสแกนบาร์โค้ดเพื่อชำระเงิน ผ่านระบบ ธนาคารออนไลน์ได้เรียบร้อยแล้วค่ะ  สมัครเป็นเพื่อนทาง Line ได้โดยค้นชื่อ การประปาส่วนภูมิภาค หรือ ผ่านคิวอาร์โค้ดได้ที่</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjPMFZSW4nSSumQxjZEM_TAHdOxHM6TzbQFEbkJ3PfGHVwwfHJdV8zxJuHBM3nAC2w2Vk821mK2Y_1G4GVb2FTOPnKZtOAo3GiiXwoCHcBPLyPj1hL9dF9espoDhnRZEIbc2OcNRW8zeQeUdgSIQPJQGmBRFudmW63qTIszZm1XYafojznfOie6kzF6QQ=s362" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="213" data-original-width="362" height="188" src="https://blogger.googleusercontent.com/img/a/AVvXsEjPMFZSW4nSSumQxjZEM_TAHdOxHM6TzbQFEbkJ3PfGHVwwfHJdV8zxJuHBM3nAC2w2Vk821mK2Y_1G4GVb2FTOPnKZtOAo3GiiXwoCHcBPLyPj1hL9dF9espoDhnRZEIbc2OcNRW8zeQeUdgSIQPJQGmBRFudmW63qTIszZm1XYafojznfOie6kzF6QQ=s320" width="320" /></a></div><br /><div><br /></div>

วิธีจ่ายค่าประปาส่วนภูมิภาคเกินกำหนด

เนื่องจากเป็นคนขี้ลืมมาก ดังนั้นบ่อยครั้งที่ค่าน้ำประปาส่วนภูมิภาค เกินชำระล่าช้า มันจะไม่มีปัญหาแม้แต่น้อย ถ้าเกิดว่า การประปาส่วนภูมิภาค...

อ่านเพิ่มเติม »

This site can't be reach แล้วใช้เน็ตไม่ได้

<p> เจอปัญหาข้อความแจ้งเออเร่อ This site can't be reach ในหน้าต่างเวบบราวเซอร์ Google chrome  และแจ้ง DNS_PROBE_FINISGED_NXDOMAIN   ปัญหานี้ทำให้ไม่สามารถใช้เวบบราวเซอร์ในการเชื่อมต่ออินเตอร์เน็ตได้  ทำให้ได้เข้าไปค้นวิธีในการแก้ไข  เพราะเจอบ่อยกับตัวจึงได้นำวิธีมาบันทึกไว้เผื่อเป็นประโยชน์สำหรับท่านใดที่เจอปัญหาค่ะ  </p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOT8l8dughoHSkcCtYpogct0gPg_MypOKqwlMkvjAXk0aoxDK2sbJ1ruJXGn1HhTPdnxMuw6H-IEo5CN3IjmNGV1vDUAnVUWAo51rB0jR8gX00VQOkLr1dkCQGnE11thhWndl1kJulujGV/s1440/%25E0%25B9%2580%25E0%25B8%258A%25E0%25B8%25B7%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B8%25A1%25E0%25B8%2595%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595%25E0%25B9%2584%25E0%25B8%25A1%25E0%25B9%2588%25E0%25B9%2584%25E0%25B8%2594%25E0%25B9%2589.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1440" data-original-width="1072" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOT8l8dughoHSkcCtYpogct0gPg_MypOKqwlMkvjAXk0aoxDK2sbJ1ruJXGn1HhTPdnxMuw6H-IEo5CN3IjmNGV1vDUAnVUWAo51rB0jR8gX00VQOkLr1dkCQGnE11thhWndl1kJulujGV/w476-h640/%25E0%25B9%2580%25E0%25B8%258A%25E0%25B8%25B7%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B8%25A1%25E0%25B8%2595%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595%25E0%25B9%2584%25E0%25B8%25A1%25E0%25B9%2588%25E0%25B9%2584%25E0%25B8%2594%25E0%25B9%2589.jpg" width="476" /></a></div><br /> <p></p><p>ปัญหานี้ดิฉันเดาว่า เกิดจาก Adware หรือพวกไวรัสในการท่องเวบ  ทำให้เจอปัญหา่ดังกล่าว เพราะสังเกตุว่าโน๊ตบุ๊คหรือ pc ที่เจอปัญหานี้มักจะมีพวกเวบไซต์ก่อกวนเด้งขึ้นรบกวนในเวบบราวเซอร์ ไม่ว่าจะเป็นพวก Firefox หรือ Google chrome  บ่อยๆ และวิธีที่ดิฉันเองใช้ได้ผลคือ ใช้โปรแกรมในการจัดการพวกไวรัสหรือ Malware  ,Adware ที่ก่อกวนในการท่องเน็ต  เช่น  <a href="https://www.malwarebytes.com/" rel="nofollow" target="_blank">Malware byte</a> และไปตั้งค่าการเชื่อมต่ออินเตอร์เน็ต ดังนี้</p><p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghIaKsVwb0Sv2GHvt6oyH8DVtiST1YsD_syEirLAbVj3qcNvm3jAlNNS9yKz7dfy2sC8DlD3WbNjz0qb1hzZzK7EXklHo24B53TojBhPtPXgQ4iEVKWwo9MZEv6PTSZxyOBeZzGu0j9XVT/s703/controlpanel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="703" data-original-width="538" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghIaKsVwb0Sv2GHvt6oyH8DVtiST1YsD_syEirLAbVj3qcNvm3jAlNNS9yKz7dfy2sC8DlD3WbNjz0qb1hzZzK7EXklHo24B53TojBhPtPXgQ4iEVKWwo9MZEv6PTSZxyOBeZzGu0j9XVT/w490-h640/controlpanel.png" width="490" /></a></div><br /><p></p><p>1. ไปที่เมนู Start  พิมพ์ค้นหา Control  Panel เจอแล้วคลิ๊กเข้าไปที่เมนู Control Panel เลยค่ะ</p><p> </p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl9-W0IbPEi669hSf8wtCfaZl9hcMtn3l8WkT4uqImg9olAGXrkd8l18jPv2F7-znnyloPBXcCityE6aQwWdbiV9gMeVFqlE-ZS0p_dBjjzPDw_RnMzFui-3d4k3i4IxLOdvarR59r-snT/s769/%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B9%2589%25E0%25B8%2587%25E0%25B8%2584%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595+2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="197" data-original-width="769" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl9-W0IbPEi669hSf8wtCfaZl9hcMtn3l8WkT4uqImg9olAGXrkd8l18jPv2F7-znnyloPBXcCityE6aQwWdbiV9gMeVFqlE-ZS0p_dBjjzPDw_RnMzFui-3d4k3i4IxLOdvarR59r-snT/w640-h164/%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B9%2589%25E0%25B8%2587%25E0%25B8%2584%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595+2.png" width="640" /></a></div><br /> <p></p><p>2. จากเมนู  Control  Panel >  Network and Internet > Network  Connections </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg0MA6pnI2vZDzkZNbAhFdSr9RLw9blgy8UheMy8hG3x10gxX4uRiepxueY0W8ND86fJTtp_097ZM__5kOSRs5e0Hyxi3LzLatsv5b5lRn9bI_26crSgoRTPcRnYxSlVtNVZ0w5TzvJa97/s501/%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B9%2589%25E0%25B8%2587%25E0%25B8%2584%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595+3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="342" data-original-width="501" height="436" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg0MA6pnI2vZDzkZNbAhFdSr9RLw9blgy8UheMy8hG3x10gxX4uRiepxueY0W8ND86fJTtp_097ZM__5kOSRs5e0Hyxi3LzLatsv5b5lRn9bI_26crSgoRTPcRnYxSlVtNVZ0w5TzvJa97/w640-h436/%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B9%2589%25E0%25B8%2587%25E0%25B8%2584%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595+3.png" width="640" /></a></div><br /><p><br /></p><p>3 คลิ๊กขวาที่ Network Adapter ที่เราใช้งาน เลื่อนไปที่เมนู Properties ดังภาพ</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmJ4Cqk6Row0s5JWleeY5tjS-T-jU6hKqla14lkuLJfrm72Hq-OsuIg1BFpBxOYAC99s9EiHXvEks_N6ByfLoe5aMDXSLJn-GESW1W8I_-_XZ-0putgUxCeg__ioNhXdRkG2qFbzXBYWee/s469/networksharing.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="365" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmJ4Cqk6Row0s5JWleeY5tjS-T-jU6hKqla14lkuLJfrm72Hq-OsuIg1BFpBxOYAC99s9EiHXvEks_N6ByfLoe5aMDXSLJn-GESW1W8I_-_XZ-0putgUxCeg__ioNhXdRkG2qFbzXBYWee/w498-h640/networksharing.png" width="498" /></a></div><p>4.ที่แถบ Sharing  เลือก Internet  Protocol Version 4 (TCP/IPv4) และคลิ๊กที่ Properties </p><p><br /></p><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0MTB6EH1nVltuU1iCyGTvzEjhniCn4jEUtGwyQrr_5DI4l_E6f7SJ8foyiYwSZppSsd-h3U76aAZQuqaQHgA5gM16wlz6Kdaw1_xhXmkZVjWVOaIDGQVm39h0WEYILGrdqzUP92yMQ2lg/s1440/%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B9%2589%25E0%25B8%2587%25E0%25B8%2584%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B8%2581%25E0%25B8%25B2%25E0%25B8%25A3%25E0%25B9%2580%25E0%25B8%258A%25E0%25B8%25B7%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B8%25A1%25E0%25B8%2595%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1440" data-original-width="1072" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0MTB6EH1nVltuU1iCyGTvzEjhniCn4jEUtGwyQrr_5DI4l_E6f7SJ8foyiYwSZppSsd-h3U76aAZQuqaQHgA5gM16wlz6Kdaw1_xhXmkZVjWVOaIDGQVm39h0WEYILGrdqzUP92yMQ2lg/w476-h640/%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B9%2589%25E0%25B8%2587%25E0%25B8%2584%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B8%2581%25E0%25B8%25B2%25E0%25B8%25A3%25E0%25B9%2580%25E0%25B8%258A%25E0%25B8%25B7%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B8%25A1%25E0%25B8%2595%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B9%2580%25E0%25B8%2599%25E0%25B9%2587%25E0%25B8%2595.jpg" width="476" /></a></div><p> </p><p>5. หากใครพบตัวเลขที่ช่อง Preferred DNS  sever และ Altemate DNS server ให้ลบตัวเลขดังกล่าวออกให้หมด แล้วกด Ok</p><p>6.หากใครไม่เจอตัวเลขใน ๆ ในสองช่องนี้ให้เติม </p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaX0-IU4A3ExZ2onTSxT7E11pMd2kTSOUCm9KY2fo9hd6rc7IYS-FNP9xfc341rSRBIbYns4tcTbhN2aKdL6nPW4Th0YinXZbXgDxJK2wajoKPJG-7xbgWUFJyZIOAuZ-_Xiyz18g0SbUK/s454/%25E0%25B9%2580%25E0%25B8%258A%25E0%25B8%25B7%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B8%25A1%25E0%25B8%2595%25E0%25B9%2588%25E0%25B8%25AD+23.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="454" data-original-width="397" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaX0-IU4A3ExZ2onTSxT7E11pMd2kTSOUCm9KY2fo9hd6rc7IYS-FNP9xfc341rSRBIbYns4tcTbhN2aKdL6nPW4Th0YinXZbXgDxJK2wajoKPJG-7xbgWUFJyZIOAuZ-_Xiyz18g0SbUK/w560-h640/%25E0%25B9%2580%25E0%25B8%258A%25E0%25B8%25B7%25E0%25B9%2588%25E0%25B8%25AD%25E0%25B8%25A1%25E0%25B8%2595%25E0%25B9%2588%25E0%25B8%25AD+23.png" width="560" /></a></div><br /><p><br /></p><p><span style="color: red;">Preferred DNS server: 8.8.8.8</span><br /><span style="color: red;">Alternate DNS server: 8.8.4.4</span><br /><span style="color: red;">ติ๊กเครื่องหมายถูกหน้าหัวข้อ Validate settings upon exit เอาไว้ด้วย  ดังภาพ</span></p><p><span style="color: red;"><strong><span style="color: black;">แล้วกด Ok หลังจากนั้นลองรีสตาร์ทเครื่องใหม่   ดิฉันใช้วิธีนี้หลายรอบได้ผล  ทดลองเอาไปใช้ดูค่ะ</span></strong><br /></span></p><p><br /></p>

This site can't be reach แล้วใช้เน็ตไม่ได้

 เจอปัญหาข้อความแจ้งเออเร่อ This site can't be reach ในหน้าต่างเวบบราวเซอร์ Google chrome  และแจ้ง DNS_PROBE_FINISGED_NXDOMAIN   ปัญหานี...

อ่านเพิ่มเติม »

ฝึกคัดลายมือภาษาอังกฤษ

<p> </p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrWDWfs7kQ3M06Y1VE4WSTzjNci8SoDw2tB7U-OZQ8plIB0MkQPn6rrq5t7TKbByTA-2dDpBNBaWTttWuYxbNZoGXrSU3Mg63QBei7Z6M6vkT1nKcq45ZlIY1rKDcxJn_mfCkac1HJIfnr/s865/%25E0%25B8%2584%25E0%25B8%25B1%25E0%25B8%2594%25E0%25B8%25A5%25E0%25B8%25B2%25E0%25B8%25A2%25E0%25B8%25A1%25E0%25B8%25B7%25E0%25B8%25AD%25E0%25B8%25AD%25E0%25B8%25B1%25E0%25B8%2587%25E0%25B8%2581%25E0%25B8%25A4%25E0%25B8%25A9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="581" data-original-width="865" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrWDWfs7kQ3M06Y1VE4WSTzjNci8SoDw2tB7U-OZQ8plIB0MkQPn6rrq5t7TKbByTA-2dDpBNBaWTttWuYxbNZoGXrSU3Mg63QBei7Z6M6vkT1nKcq45ZlIY1rKDcxJn_mfCkac1HJIfnr/s320/%25E0%25B8%2584%25E0%25B8%25B1%25E0%25B8%2594%25E0%25B8%25A5%25E0%25B8%25B2%25E0%25B8%25A2%25E0%25B8%25A1%25E0%25B8%25B7%25E0%25B8%25AD%25E0%25B8%25AD%25E0%25B8%25B1%25E0%25B8%2587%25E0%25B8%2581%25E0%25B8%25A4%25E0%25B8%25A9.png" width="320" /></a></div><br /> <p></p><p>ทดลองให้เด็กๆใช้คัดลายมือ   เพราะว่าโปรแกรมนี้มีฟังก์ชั่นให้รู้ว่าการลากเส้นในภาษาอังกฤษเริ่มต้นตรงจุดไหน ไปสิ้นสุดที่ไหน   ดังนั้นฝึกลายมือเบื้องต้นเหมาะมากๆ สำหรับเด็ก ๆ  แม้แต่ฝึกการเขียนตัวเขียน (Cursive)  ก็มีฟ้อนท์ให้เรียนรู้ตัวเขียนอังกฤษ  ง่ายมาก </p><p> </p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiDsyKuyhj4y-Y-MlOIqj2wYZ7VtkmUF1KooHMLO6_PHypv0l54Oo4HtSfYasiYKqGSMxRbjh2ZUE6QGK2q50NuMmPyEDdmsSHbmP6edVO5I3O3X3tX9BB5AOcIRnx2ZSFauq6TAWcvAK9/s847/cursive.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="521" data-original-width="847" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiDsyKuyhj4y-Y-MlOIqj2wYZ7VtkmUF1KooHMLO6_PHypv0l54Oo4HtSfYasiYKqGSMxRbjh2ZUE6QGK2q50NuMmPyEDdmsSHbmP6edVO5I3O3X3tX9BB5AOcIRnx2ZSFauq6TAWcvAK9/s320/cursive.png" width="320" /></a></div><br /> <p></p><p>สามารถแทรกรูปภาพ  (Clipart)ให้เด็กๆ ไประบายสีได้เพิ่มเติม เมนูใช้งานไม่ยาก ลองดาวน์โหลดไปทดลองใช้กันดูค่ะ  <a href="https://1drv.ms/u/s!AnDtakvI4JTzhG2ZmdR42rIW21qF?e=GZucUE" rel="nofollow" target="_blank"> ฝึกคัดลายมือภาษาอังกฤษ</a><br /></p><p><br /></p>

ฝึกคัดลายมือภาษาอังกฤษ

    ทดลองให้เด็กๆใช้คัดลายมือ   เพราะว่าโปรแกรมนี้มีฟังก์ชั่นให้รู้ว่าการลากเส้นในภาษาอังกฤษเริ่มต้นตรงจุดไหน ไปสิ้นสุดที่ไหน   ดังนั้นฝึกลา...

อ่านเพิ่มเติม »