{"id":4146,"date":"2023-05-09T21:04:00","date_gmt":"2023-05-09T18:04:00","guid":{"rendered":"https:\/\/global.tab-tv.com\/hu\/?p=4146"},"modified":"2023-05-10T00:14:42","modified_gmt":"2023-05-09T21:14:42","slug":"a-mai-datum-hozzaadasa-a-microsoft-excelben","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/hu\/a-mai-datum-hozzaadasa-a-microsoft-excelben\/","title":{"rendered":"Hogyan illessz\u00fck be a mai d\u00e1tumot az Excelben"},"content":{"rendered":"\n<p>\u00d6n Excel-felhaszn\u00e1l\u00f3, akinek fontos d\u00e1tumokat kell nyomon k\u00f6vetnie? Gyakran \u00edrja be k\u00e9zzel az aktu\u00e1lis d\u00e1tumot, hogy k\u00e9s\u0151bb r\u00e1j\u00f6jj\u00f6n, hogy azt friss\u00edteni kell? Hat\u00e9konyabb m\u00f3dot keres arra, hogy a mai d\u00e1tumot beillessze az Excel t\u00e1bl\u00e1zatokba? Ha igen, akkor szerencs\u00e9je van.<\/p>\n\n\n\n<p>A mai d\u00e1tum beilleszt\u00e9s\u00e9re az Excelben t\u00f6bbf\u00e9le m\u00f3dszer is haszn\u00e1lhat\u00f3, az egyszer\u0171 k\u00e9zi bevitelt\u0151l kezdve a fejlettebb VBA-makr\u00f3kig. Ig\u00e9nyeit\u0151l f\u00fcgg\u0151en v\u00e1laszthat statikus vagy dinamikus d\u00e1tum\u00e9rt\u00e9ket. M\u00e1s sz\u00f3val, hogy a d\u00e1tum friss\u00fcl-e vagy sem.<\/p>\n\n\n\n<p>A k\u00f6vetkez\u0151k\u00e9ppen m\u0171k\u00f6dik.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Statikus d\u00e1tum hozz\u00e1ad\u00e1sa az Excelben<\/strong><\/h2>\n\n\n\n<p>Azt gondolhatod, hogy egyszer\u0171bb manu\u00e1lisan hozz\u00e1adni a d\u00e1tumot. Ez azt jelenti, hogy kijel\u00f6lheti a cell\u00e1t, ahov\u00e1 a d\u00e1tumot be akarja \u00edrni, majd be\u00edrhatja a mai d\u00e1tumot a k\u00edv\u00e1nt form\u00e1tumban. Ha p\u00e9ld\u00e1ul a DD\/MM\/YYYY form\u00e1tumban szeretn\u00e9 megadni, akkor a cell\u00e1ba be\u00edrhatja a &#8222;13\/04\/2023&#8221; sz\u00f6veget.<\/p>\n\n\n\n<p>A mai d\u00e1tum hozz\u00e1ad\u00e1sa a parancsikon haszn\u00e1lat\u00e1val azonban m\u00e9g gyorsabb. Ehhez k\u00f6vesse az al\u00e1bbi l\u00e9p\u00e9seket:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jel\u00f6lje ki azt a cell\u00e1t, amelybe a d\u00e1tumot be akarja \u00edrni.<\/li>\n\n\n\n<li>Ezut\u00e1n nyomja meg a <strong>Ctrl + ; <\/strong>(pontosvessz\u0151) billenty\u0171kombin\u00e1ci\u00f3t.<\/li>\n\n\n\n<li>Ez automatikusan a mai d\u00e1tumot \u00edrja be a cell\u00e1ba.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6604\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-1.webp 816w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-1-300x268.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-1-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Az aktu\u00e1lis id\u0151 hozz\u00e1ad\u00e1s\u00e1hoz nyomja le a <strong>Ctrl + Shift + ; <\/strong>(pontosvessz\u0151) billenty\u0171kombin\u00e1ci\u00f3t.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-6603\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-2.webp 816w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-2-300x268.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-2-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p>Ezenk\u00edv\u00fcl az aktu\u00e1lis d\u00e1tumot \u00e9s id\u0151t egyszerre adhatja hozz\u00e1 ugyanahhoz a cell\u00e1hoz. \u00cdme, hogyan:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jel\u00f6lje ki a k\u00edv\u00e1nt cell\u00e1t, \u00e9s nyomja meg a <strong>Ctrl + ; <\/strong>(pontosvessz\u0151) billenty\u0171kombin\u00e1ci\u00f3t.<\/li>\n\n\n\n<li>Ezut\u00e1n maradjon ebben a cell\u00e1ban, \u00e9s nyomja meg a <strong>Space <\/strong>billenty\u0171t.<\/li>\n\n\n\n<li>V\u00e9g\u00fcl nyomja le a <strong>Ctrl + Shift + ; <\/strong>(pontosvessz\u0151) billenty\u0171kombin\u00e1ci\u00f3t.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-3.webp\" alt=\"\" class=\"wp-image-6602\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-3.webp 816w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-3-300x268.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-add-a-static-date-in-Excel-3-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p>A parancsikon j\u00f3 megold\u00e1s, ha csak alkalmank\u00e9nt kell beillesztenie a d\u00e1tumot, de ha gyakran kell ezt megtennie, akkor \u00e9rdemes megfontolnia a t\u00f6bbi m\u00f3dszer valamelyik\u00e9t.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>A TODAY() f\u00fcggv\u00e9ny haszn\u00e1lata a mai d\u00e1tum beilleszt\u00e9s\u00e9hez az Excelben<\/strong><\/h2>\n\n\n\n<p>A TODAY() f\u00fcggv\u00e9ny az Excel be\u00e9p\u00edtett f\u00fcggv\u00e9nye, amely az aktu\u00e1lis d\u00e1tumot adja vissza. Praktikus, ha d\u00e1tumokkal dolgozik, mivel mindig az aktu\u00e1lis d\u00e1tumot adja vissza, f\u00fcggetlen\u00fcl att\u00f3l, hogy mikor nyitja meg a f\u00e1jlt. A f\u00fcggv\u00e9ny szintaxisa egyszer\u0171: =TODAY(). Ezt a f\u00fcggv\u00e9nyt b\u00e1rmely olyan cell\u00e1ban haszn\u00e1lhatja, ahol az aktu\u00e1lis d\u00e1tumot kell megjelen\u00edtenie.<\/p>\n\n\n\n<p>Teh\u00e1t itt van, hogyan kell haszn\u00e1lni:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u00e1lassza ki azt a cell\u00e1t, ahol a mai d\u00e1tumot szeretn\u00e9 megjelen\u00edteni.<\/li>\n\n\n\n<li>Ezut\u00e1n \u00edrja be a <strong>&#8222;=TODAY()&#8221; parancsot<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"729\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6601\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1.webp 816w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1-300x268.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1-768x686.webp 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p>Ez a mai d\u00e1tumot jelen\u00edti meg a cell\u00e1ban, \u00e9s a d\u00e1tum minden nap automatikusan friss\u00fcl.<\/p>\n\n\n\n<p>Ott van m\u00e9g a NOW() f\u00fcggv\u00e9ny. Az aktu\u00e1lis d\u00e1tumot \u00e9s id\u0151t is beilleszti egy Excel t\u00e1bl\u00e1zatba. A k\u00e9plet szintaxisa egyszer\u0171: \u00edrja be a =NOW() f\u00fcggv\u00e9nyt abba a cell\u00e1ba, ahol az aktu\u00e1lis d\u00e1tumot \u00e9s id\u0151t szeretn\u00e9 megjelen\u00edteni.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"719\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-6600\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2.webp 806w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2-300x268.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2-768x685.webp 768w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/figure>\n\n\n\n<p>Ez hasonl\u00f3an m\u0171k\u00f6dik, mint a TODAY() f\u00fcggv\u00e9ny. Automatikusan friss\u00fcl minden alkalommal, amikor megnyitja az Excel-f\u00e1jlt.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Hogyan haszn\u00e1ljuk a VBA makr\u00f3t a mai d\u00e1tum beilleszt\u00e9s\u00e9hez az Excelben?<\/strong><\/h2>\n\n\n\n<p>Egy VBA makr\u00f3val automatiz\u00e1lhatja a mai d\u00e1tum beilleszt\u00e9s\u00e9t az Excelben. A makr\u00f3 l\u00e9trehoz\u00e1s\u00e1hoz k\u00f6vesse az al\u00e1bbi utas\u00edt\u00e1sokat:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kattintson a <strong>Fejleszt\u0151 <\/strong>f\u00fclre, \u00e9s nyissa meg a <strong>Visual Basic szerkeszt\u0151t<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"815\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6599\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1.webp 940w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1-300x260.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1-768x666.webp 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ezut\u00e1n kattintson a <strong>Besz\u00far\u00e1s <\/strong>gombra, \u00e9s v\u00e1lassza a <strong>Modul lehet\u0151s\u00e9get<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"698\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-6598\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2.webp 977w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-300x214.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-768x549.webp 768w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-100x70.webp 100w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ezut\u00e1n \u00edrja be a k\u00f6vetkez\u0151 k\u00f3dot:<\/li>\n<\/ul>\n\n\n\n<p>Sub InsertTodayDate()<\/p>\n\n\n\n<p>ActiveCell.Value = D\u00e1tum<\/p>\n\n\n\n<p>End Sub<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"706\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3.webp\" alt=\"\" class=\"wp-image-6597\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3.webp 984w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3-300x215.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3-768x551.webp 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A makr\u00f3 haszn\u00e1lat\u00e1hoz mentse el a f\u00e1jlt makr\u00f3val rendelkez\u0151 munkaf\u00fczetk\u00e9nt.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"949\" height=\"819\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4.webp\" alt=\"\" class=\"wp-image-6596\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4.webp 949w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4-300x259.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4-768x663.webp 768w\" sizes=\"auto, (max-width: 949px) 100vw, 949px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ezut\u00e1n nyissa meg a f\u00e1jlt, l\u00e9pjen ism\u00e9t a <strong>Fejleszt\u0151 <\/strong>f\u00fclre, \u00e9s kattintson a <strong>Makr\u00f3k <\/strong>gombra.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"943\" height=\"814\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5.webp\" alt=\"\" class=\"wp-image-6595\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5.webp 943w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5-300x259.webp 300w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5-768x663.webp 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u00e9g\u00fcl v\u00e1lassza ki a l\u00e9trehozott makr\u00f3t, \u00e9s kattintson a <strong>Futtat\u00e1s <\/strong>gombra.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"391\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6.webp\" alt=\"\" class=\"wp-image-6594\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6.webp 400w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6-300x293.webp 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure>\n\n\n\n<p>Ez a makr\u00f3 beilleszti a mai d\u00e1tumot az akt\u00edv cell\u00e1ba.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Hogyan v\u00e1ltoztathatja meg a d\u00e1tumform\u00e1tumot az Excelben<\/strong><\/h2>\n\n\n\n<p>A d\u00e1tumform\u00e1tum megv\u00e1ltoztat\u00e1sa az Excelben egy egyszer\u0171 folyamat, amely seg\u00edthet a d\u00e1tumok sz\u00fcks\u00e9ges form\u00e1tumban t\u00f6rt\u00e9n\u0151 megjelen\u00edt\u00e9s\u00e9ben. Teh\u00e1t itt van, hogyan kell ezt megtenni:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jel\u00f6lje ki a form\u00e1zni k\u00edv\u00e1nt d\u00e1tumokat tartalmaz\u00f3 cell\u00e1t vagy cellatartom\u00e1nyt.<\/li>\n\n\n\n<li>Kattintson a jobb gombbal a kijel\u00f6lt cell\u00e1ra (cell\u00e1kra), \u00e9s v\u00e1lassza a men\u00fcb\u0151l a <strong>Cell\u00e1k form\u00e1z\u00e1sa <\/strong>parancsot.<\/li>\n\n\n\n<li>V\u00e1lassza ki a <strong>d\u00e1tumot <\/strong>a <strong>kateg\u00f3ria <\/strong>list\u00e1b\u00f3l.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"512\" src=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-change-the-date-format-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6592\" srcset=\"https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-change-the-date-format-in-Excel-1.webp 560w, https:\/\/global.tab-tv.com\/hu\/wp-content\/uploads\/sites\/3\/2023\/05\/How-to-change-the-date-format-in-Excel-1-300x274.webp 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u00e1lassza ki a k\u00edv\u00e1nt d\u00e1tumform\u00e1tumot a <strong>T\u00edpus <\/strong>list\u00e1b\u00f3l.<\/li>\n\n\n\n<li>Az Excel sz\u00e1mos el\u0151re meghat\u00e1rozott d\u00e1tumform\u00e1tumot biztos\u00edt, p\u00e9ld\u00e1ul <strong>mm\/dd\/yyyy <\/strong>vagy <strong>dd-mmm-yy<\/strong>. De l\u00e9trehozhatja egy\u00e9ni form\u00e1tum\u00e1t is, ha be\u00edrja azt a <strong>T\u00edpus <\/strong>mez\u0151be.<\/li>\n\n\n\n<li>Kattintson az <strong>OK <\/strong>gombra az \u00faj form\u00e1tum alkalmaz\u00e1s\u00e1hoz a kijel\u00f6lt cell\u00e1ra (cell\u00e1kra).<\/li>\n<\/ul>\n\n\n\n<p>Miut\u00e1n megv\u00e1ltoztatta a d\u00e1tumform\u00e1tumot, az Excel a kiv\u00e1lasztott \u00faj form\u00e1tumban jelen\u00edti meg a d\u00e1tumokat. Ez seg\u00edthet a t\u00e1bl\u00e1zatok olvashat\u00f3bb\u00e1 \u00e9s k\u00f6nnyebben \u00e9rthet\u0151v\u00e9 t\u00e9tel\u00e9ben, k\u00fcl\u00f6n\u00f6sen akkor, ha megosztja azokat m\u00e1sokkal, akik esetleg m\u00e1s d\u00e1tumform\u00e1tumokkal dolgoznak.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00d6n Excel-felhaszn\u00e1l\u00f3, akinek fontos d\u00e1tumokat kell nyomon k\u00f6vetnie? Gyakran \u00edrja be k\u00e9zzel az aktu\u00e1lis d\u00e1tumot, hogy k\u00e9s\u0151bb r\u00e1j\u00f6jj\u00f6n, hogy azt friss\u00edteni kell? Hat\u00e9konyabb m\u00f3dot keres arra, hogy a mai d\u00e1tumot beillessze az Excel t\u00e1bl\u00e1zatokba? Ha igen, akkor szerencs\u00e9je van. A mai d\u00e1tum beilleszt\u00e9s\u00e9re az Excelben t\u00f6bbf\u00e9le m\u00f3dszer is haszn\u00e1lhat\u00f3, az egyszer\u0171 k\u00e9zi bevitelt\u0151l kezdve a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6605,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2],"tags":[30],"class_list":{"0":"post-4146","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-utmutatok","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/posts\/4146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/comments?post=4146"}],"version-history":[{"count":3,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/posts\/4146\/revisions"}],"predecessor-version":[{"id":6606,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/posts\/4146\/revisions\/6606"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/media\/6605"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/media?parent=4146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/categories?post=4146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/hu\/wp-json\/wp\/v2\/tags?post=4146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}