{"id":4142,"date":"2023-05-09T21:05:00","date_gmt":"2023-05-09T18:05:00","guid":{"rendered":"https:\/\/global.tab-tv.com\/sk\/?p=4142"},"modified":"2023-05-10T00:17:13","modified_gmt":"2023-05-09T21:17:13","slug":"ako-pridat-dnesny-datum-v-programe-microsoft-excel","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/sk\/ako-pridat-dnesny-datum-v-programe-microsoft-excel\/","title":{"rendered":"Ako vlo\u017ei\u0165 dne\u0161n\u00fd d\u00e1tum v programe Excel"},"content":{"rendered":"\n<p>Ste pou\u017e\u00edvate\u013eom programu Excel, ktor\u00fd potrebuje sledova\u0165 d\u00f4le\u017eit\u00e9 d\u00e1tumy? \u010casto ru\u010dne zad\u00e1vate aktu\u00e1lny d\u00e1tum, aby ste nesk\u00f4r zistili, \u017ee ho treba aktualizova\u0165? H\u013ead\u00e1te efekt\u00edvnej\u0161\u00ed sp\u00f4sob vkladania dne\u0161n\u00e9ho d\u00e1tumu do tabuliek programu Excel? Ak \u00e1no, m\u00e1te \u0161\u0165astie.<\/p>\n\n\n\n<p>Na vlo\u017eenie dne\u0161n\u00e9ho d\u00e1tumu v programe Excel m\u00f4\u017eete pou\u017ei\u0165 nieko\u013eko met\u00f3d, od jednoduch\u00fdch ru\u010dn\u00fdch z\u00e1pisov a\u017e po pokro\u010dilej\u0161ie makr\u00e1 VBA. V z\u00e1vislosti od va\u0161ich potrieb si m\u00f4\u017eete vybra\u0165 statick\u00fa alebo dynamick\u00fa hodnotu d\u00e1tumu. In\u00fdmi slovami, \u010di sa d\u00e1tum bude aktualizova\u0165 alebo nie.<\/p>\n\n\n\n<p>Funguje to takto.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako prida\u0165 statick\u00fd d\u00e1tum v programe Excel<\/strong><\/h2>\n\n\n\n<p>Mo\u017eno si mysl\u00edte, \u017ee je jednoduch\u0161ie prida\u0165 d\u00e1tum ru\u010dne. To znamen\u00e1, \u017ee m\u00f4\u017eete vybra\u0165 bunku, do ktorej chcete zada\u0165 d\u00e1tum, a potom zada\u0165 dne\u0161n\u00fd d\u00e1tum v po\u017eadovanom form\u00e1te. Ak ho napr\u00edklad chcete zada\u0165 vo form\u00e1te DD\/MM\/RRRR, m\u00f4\u017eete do bunky zada\u0165 &#8220;13\/04\/2023&#8221;.<\/p>\n\n\n\n<p>Pridanie dne\u0161n\u00e9ho d\u00e1tumu pomocou skratky je v\u0161ak e\u0161te r\u00fdchlej\u0161ie. Ak to chcete urobi\u0165, postupujte pod\u013ea nasleduj\u00facich krokov:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vyberte bunku, do ktorej chcete zada\u0165 d\u00e1tum.<\/li>\n\n\n\n<li>Potom stla\u010dte <strong>kl\u00e1vesov\u00fa skratku Ctrl + ; <\/strong>(bodko\u010diarka).<\/li>\n\n\n\n<li>T\u00fdm sa do bunky automaticky zad\u00e1 dne\u0161n\u00fd d\u00e1tum.<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6610\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-1.webp 816w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-1-300x268.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Ak chcete prida\u0165 aktu\u00e1lny \u010das, stla\u010dte <strong>kl\u00e1vesov\u00fa skratku Ctrl + Shift + ; <\/strong>(bodko\u010diarka).<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-6609\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-2.webp 816w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-2-300x268.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Okrem toho m\u00f4\u017eete do tej istej bunky prida\u0165 aktu\u00e1lny d\u00e1tum a \u010das s\u00fa\u010dasne. Tu je n\u00e1vod, ako na to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vyberte potrebn\u00fa bunku a stla\u010dte <strong>kl\u00e1vesov\u00fa skratku Ctrl + ; <\/strong>(bodko\u010diarka).<\/li>\n\n\n\n<li>Potom zosta\u0148te v tejto bunke a stla\u010dte <strong>medzern\u00edk<\/strong>.<\/li>\n\n\n\n<li>Nakoniec stla\u010dte <strong>kl\u00e1vesov\u00fa skratku Ctrl + Shift + ; <\/strong>(bodko\u010diarka).<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-3.webp\" alt=\"\" class=\"wp-image-6608\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-3.webp 816w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-add-a-static-date-in-Excel-3-300x268.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Skratka je dobrou vo\u013ebou, ak potrebujete vlo\u017ei\u0165 d\u00e1tum len ob\u010das, ale ak to potrebujete robi\u0165 \u010dasto, mo\u017eno budete chcie\u0165 zv\u00e1\u017ei\u0165 niektor\u00fa z \u010fal\u0161\u00edch met\u00f3d.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako pou\u017e\u00edva\u0165 funkciu TODAY() na vlo\u017eenie dne\u0161n\u00e9ho d\u00e1tumu v programe Excel<\/strong><\/h2>\n\n\n\n<p>Funkcia TODAY() je vstavan\u00e1 funkcia v programe Excel, ktor\u00e1 vracia aktu\u00e1lny d\u00e1tum. Je u\u017eito\u010dn\u00e1 pri pr\u00e1ci s d\u00e1tumami, preto\u017ee v\u017edy vr\u00e1ti aktu\u00e1lny d\u00e1tum bez oh\u013eadu na to, kedy otvor\u00edte s\u00fabor. Syntax funkcie je jednoduch\u00e1: =TODAY(). T\u00fato funkciu m\u00f4\u017eete pou\u017ei\u0165 v akejko\u013evek bunke, v ktorej potrebujete zobrazi\u0165 aktu\u00e1lny d\u00e1tum.<\/p>\n\n\n\n<p>Tu je n\u00e1vod, ako ho pou\u017e\u00edva\u0165:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vyberte bunku, v ktorej chcete zobrazi\u0165 dne\u0161n\u00fd d\u00e1tum.<\/li>\n\n\n\n<li>Potom zadajte <strong>&#8220;=TODAY()&#8221;<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6607\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1.webp 816w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-1-300x268.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>V bunke sa zobraz\u00ed dne\u0161n\u00fd d\u00e1tum a d\u00e1tum sa bude automaticky aktualizova\u0165 ka\u017ed\u00fd de\u0148.<\/p>\n\n\n\n<p>K dispoz\u00edcii je aj funkcia NOW(). Do tabu\u013eky programu Excel vlo\u017e\u00ed aktu\u00e1lny d\u00e1tum aj \u010das. Syntax vzorca je jednoduch\u00e1: do bunky, v ktorej chcete zobrazi\u0165 aktu\u00e1lny d\u00e1tum a \u010das, zadajte =NOW().<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-6606\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2.webp 806w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-the-TODAY-function-to-insert-todays-date-in-Excel-2-300x268.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Funguje to podobne ako funkcia TODAY(). Automaticky sa aktualizuje pri ka\u017edom otvoren\u00ed s\u00faboru Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako pou\u017e\u00edva\u0165 makro VBA na vlo\u017eenie dne\u0161n\u00e9ho d\u00e1tumu v programe Excel<\/strong><\/h2>\n\n\n\n<p>Na automatizovan\u00e9 vlo\u017eenie dne\u0161n\u00e9ho d\u00e1tumu do aplik\u00e1cie Excel m\u00f4\u017eete pou\u017ei\u0165 makro VBA. Ak chcete vytvori\u0165 makro, postupujte pod\u013ea t\u00fdchto pokynov:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kliknite na kartu <strong>V\u00fdvoj\u00e1r <\/strong>a otvorte <strong>editor jazyka Visual Basic<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6605\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1.webp 940w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-1-300x260.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Potom kliknite na tla\u010didlo <strong>Vlo\u017ei\u0165 <\/strong>a vyberte polo\u017eku <strong>Modul<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2.webp\" alt=\"\" class=\"wp-image-6604\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2.webp 977w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-300x214.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-2-768x549.webp 768w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Potom zadajte nasleduj\u00faci k\u00f3d:<\/li>\n<\/ul>\n\n\n\n<p>Sub InsertTodayDate()<\/p>\n\n\n\n<p>ActiveCell.Value = Date<\/p>\n\n\n\n<p>Koniec 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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3.webp\" alt=\"\" class=\"wp-image-6603\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3.webp 984w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-3-300x215.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Ak chcete makro pou\u017ei\u0165, ulo\u017ete s\u00fabor ako zo\u0161it s povolen\u00fdmi makrami.<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4.webp\" alt=\"\" class=\"wp-image-6602\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4.webp 949w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-4-300x259.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Potom otvorte s\u00fabor, op\u00e4\u0165 prejdite na kartu <strong>V\u00fdvoj\u00e1r a <\/strong>kliknite na polo\u017eku <strong>Makr\u00e1<\/strong>.<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5.webp\" alt=\"\" class=\"wp-image-6601\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5.webp 943w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-5-300x259.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Nakoniec vyberte vytvoren\u00e9 makro a kliknite na tla\u010didlo <strong>Spusti\u0165<\/strong>.<\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6.webp\" alt=\"\" class=\"wp-image-6600\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-use-VBA-Macro-to-insert-todays-date-in-Excel-6.webp 400w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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>Toto makro vlo\u017e\u00ed do akt\u00edvnej bunky dne\u0161n\u00fd d\u00e1tum.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako zmeni\u0165 form\u00e1t d\u00e1tumu v programe Excel<\/strong><\/h2>\n\n\n\n<p>Zmena form\u00e1tu d\u00e1tumu v programe Excel je jednoduch\u00fd proces, ktor\u00fd v\u00e1m pom\u00f4\u017ee zobrazi\u0165 d\u00e1tumy v potrebnom form\u00e1te. Tu je n\u00e1vod, ako to urobi\u0165:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vyberte bunku alebo rozsah buniek, ktor\u00e9 obsahuj\u00fa d\u00e1tumy, ktor\u00e9 chcete form\u00e1tova\u0165.<\/li>\n\n\n\n<li>Kliknite prav\u00fdm tla\u010didlom my\u0161i na vybran\u00e9 bunky a z ponuky vyberte polo\u017eku <strong>Form\u00e1tova\u0165 bunky<\/strong>.<\/li>\n\n\n\n<li>V zozname <strong>Kateg\u00f3ria <\/strong>vyberte polo\u017eku <strong>D\u00e1tum.<\/strong><\/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\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-change-the-date-format-in-Excel-1.webp\" alt=\"\" class=\"wp-image-6598\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2023\/05\/How-to-change-the-date-format-in-Excel-1.webp 560w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/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 zozname <strong>Typ <\/strong>vyberte po\u017eadovan\u00fd form\u00e1t d\u00e1tumu.<\/li>\n\n\n\n<li>Excel poskytuje nieko\u013eko preddefinovan\u00fdch form\u00e1tov d\u00e1tumu, ako napr\u00edklad <strong>mm\/dd\/rrrr <\/strong>alebo <strong>dd-mmm-r<\/strong>. M\u00f4\u017eete si v\u0161ak vytvori\u0165 aj vlastn\u00fd form\u00e1t zadan\u00edm do po\u013ea <strong>Typ.<\/strong><\/li>\n\n\n\n<li>Kliknut\u00edm na tla\u010didlo <strong>OK <\/strong>aplikujte nov\u00fd form\u00e1t na vybran\u00e9 bunky.<\/li>\n<\/ul>\n\n\n\n<p>Po zmene form\u00e1tu d\u00e1tumu bude Excel zobrazova\u0165 d\u00e1tumy v novom form\u00e1te, ktor\u00fd ste vybrali. To m\u00f4\u017ee pom\u00f4c\u0165, aby boli va\u0161e tabu\u013eky \u010ditate\u013enej\u0161ie a zrozumite\u013enej\u0161ie, najm\u00e4 ak ich zdie\u013eate s in\u00fdmi pou\u017e\u00edvate\u013emi, ktor\u00ed m\u00f4\u017eu pracova\u0165 s in\u00fdmi form\u00e1tmi d\u00e1tumov.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ste pou\u017e\u00edvate\u013eom programu Excel, ktor\u00fd potrebuje sledova\u0165 d\u00f4le\u017eit\u00e9 d\u00e1tumy? \u010casto ru\u010dne zad\u00e1vate aktu\u00e1lny d\u00e1tum, aby ste nesk\u00f4r zistili, \u017ee ho treba aktualizova\u0165? H\u013ead\u00e1te efekt\u00edvnej\u0161\u00ed sp\u00f4sob vkladania dne\u0161n\u00e9ho d\u00e1tumu do tabuliek programu Excel? Ak \u00e1no, m\u00e1te \u0161\u0165astie. Na vlo\u017eenie dne\u0161n\u00e9ho d\u00e1tumu v programe Excel m\u00f4\u017eete pou\u017ei\u0165 nieko\u013eko met\u00f3d, od jednoduch\u00fdch ru\u010dn\u00fdch z\u00e1pisov a\u017e po pokro\u010dilej\u0161ie makr\u00e1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6611,"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-4142","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sprievodcovia","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/4142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/comments?post=4142"}],"version-history":[{"count":3,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/4142\/revisions"}],"predecessor-version":[{"id":6612,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/4142\/revisions\/6612"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media\/6611"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media?parent=4142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/categories?post=4142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/tags?post=4142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}