{"id":383,"date":"2020-06-23T08:35:00","date_gmt":"2020-06-23T06:35:00","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=383"},"modified":"2020-06-23T09:12:33","modified_gmt":"2020-06-23T07:12:33","slug":"egyeni-datumformatum","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/","title":{"rendered":"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot"},"content":{"rendered":"<p style=\"text-align: left;\"><strong>K\u00e9rd\u00e9s:&nbsp;<\/strong>A f\u0151n\u00f6k\u00f6m ragaszkodik egy sp\u00e9ci d\u00e1tumform\u00e1tumhoz. Azt akarja, hogy a d\u00e1tumokat \u00edrjam \u00e1t &#8216;szept. 3, kedd&#8217; form\u00e1tumba. Semmi kedvem egyes\u00e9vel \u00e1t\u00edrni 500 adatot. Van erre valami egyszer\u0171bb m\u00f3dszer?<!--more--><\/p>\n<p><strong><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/egyeni-datum1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft size-full wp-image-1724\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/egyeni-datum1.jpg\" alt=\"egyeni-datum\" width=\"236\" height=\"216\"><\/a>V\u00e1lasz:&nbsp;<\/strong>&nbsp;Ha nem tal\u00e1lsz megfelel\u0151 d\u00e1tumform\u00e1tumot, akkor a Cellaform\u00e1z\u00e1s ablak Sz\u00e1m f\u00fcl\u00f6n az <strong>Egy\u00e9ni kateg\u00f3ri\u00e1t<\/strong>&nbsp;v\u00e1laszd, ahol egy\u00e9ni form\u00e1tumk\u00f3dokat tudsz megadni.<\/p>\n<p>D\u00e1tumok eset\u00e9ben az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket haszn\u00e1ld.<\/p>\n\n\n<p class=\"has-text-color has-background has-very-dark-gray-color has-very-light-gray-background-color\">Ha angol nyelv\u0171 az Exceled, akkor val\u00f3z\u00edn\u0171leg az y (year), m (month), d (day) bet\u0171kkel fog m\u0171k\u00f6dni.<\/p>\n\n\n\n<p>Att\u00f3l f\u00fcgg\u0151en, hogy h\u00e1nyszor \u00edrod be az adott bet\u0171t, m\u00e1s fog megjelenni. <\/p>\n\n\n\n<p>Pl. szeptember 3 kedd eset\u00e9n:<br><strong>h<\/strong> = 9, <strong>hh<\/strong> = 09, <strong>hhh<\/strong> = szept., <strong>hhhh<\/strong> =&nbsp;szeptember<br><strong>n<\/strong> = 3, <strong>nn<\/strong> = 03, <strong>nnn<\/strong> = K, <strong>nnnn<\/strong> =&nbsp;kedd<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa<\/h2>\n\n\n\n<p>V\u00e1laszd a <strong>Cellaform\u00e1z\u00e1s (Ctrl 1) \/ Egy\u00e9ni sz\u00e1mform\u00e1tumot<\/strong>, kattints a Form\u00e1tumk\u00f3d mez\u0151be \u00e9s t\u00f6r\u00f6ld ki a benne l\u00e9v\u0151 form\u00e1tumot, majd kezdd el be\u00edrni a haszn\u00e1lni k\u00edv\u00e1nt form\u00e1t. A mint\u00e1n\u00e1l nyomon tudod k\u00f6vetni az eredm\u00e9nyt.<\/p>\n\n\n\n<p>K\u00fcl\u00f6nb\u00f6z\u0151 vari\u00e1ci\u00f3kat hozhatsz l\u00e9t\u00e9re &nbsp;a h, n, \u00e9 bet\u0171kb\u0151l, amelyeket tetsz\u0151leges karakterekkel kombin\u00e1lhatsz. P\u00e9ld\u00e1ul:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151.jpg\" alt=\"\" class=\"wp-image-2285\" width=\"333\" height=\"207\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151.jpg 800w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-660x413.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-240x150.jpg 240w\" sizes=\"(max-width: 333px) 100vw, 333px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>szeptember 3, kedd<\/strong> eredm\u00e9nyhez a k\u00f6vetkez\u0151 k\u00f3dot haszn\u00e1ld: hhhh n, nnnn<\/li><li><strong>2020-dec<\/strong> t\u00edpus\u00fa d\u00e1tumhoz: \u00e9\u00e9\u00e9\u00e9-hhh<\/li><li>Ha csak a napokat akarod l\u00e1tni <strong>V 9, H 10, K 11<\/strong> form\u00e1ban, akkor: nnn n<\/li><\/ul>\n\n\n\n<p>Fontos megjegyezned, hogy a Sz\u00e1mform\u00e1tummal mindig csak a megjelen\u00edt\u00e9st m\u00f3dos\u00edtod. A cella tartalma nem v\u00e1ltozik, a <a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/excel-datum-44000-nap\/\" target=\"_blank\">d\u00e1tum ugyanaz a 44 ezer k\u00f6r\u00fcli sz\u00e1m marad a h\u00e1tt\u00e9rben<\/a>.<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/GKsY6pwCWbY\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<h2 class=\"wp-block-heading\">Ez is \u00e9rdekelhet<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/\"><img decoding=\"async\" width=\"1024\" height=\"256\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz-1024x256.png\" alt=\"\" class=\"wp-image-5713\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz-1024x256.png 1024w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz-300x75.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz-768x192.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz-660x165.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz-240x60.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"311\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog-1024x311.png\" alt=\"\" class=\"wp-image-7189\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog-1024x311.png 1024w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog-300x91.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog-768x233.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog-660x200.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog-240x73.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-flashfill-blog.png 1400w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n","protected":false},"excerpt":{"rendered":"<p>K\u00e9rd\u00e9s:&nbsp;A f\u0151n\u00f6k\u00f6m ragaszkodik egy sp\u00e9ci d\u00e1tumform\u00e1tumhoz. Azt akarja, hogy a d\u00e1tumokat \u00edrjam \u00e1t &#8216;szept. 3, kedd&#8217; form\u00e1tumba. Semmi kedvem egyes\u00e9vel \u00e1t\u00edrni 500 adatot. Van erre valami egyszer\u0171bb m\u00f3dszer?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[8],"class_list":["post-383","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-datum"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa: Cellaform\u00e1z\u00e1s \/ Sz\u00e1m f\u00fcl \/ Egy\u00e9ni kateg\u00f3ri\u00e1n\u00e1l haszn\u00e1ld az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa: Cellaform\u00e1z\u00e1s \/ Sz\u00e1m f\u00fcl \/ Egy\u00e9ni kateg\u00f3ri\u00e1n\u00e1l haszn\u00e1ld az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-23T06:35:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-23T07:12:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today.png\" \/>\n\t<meta property=\"og:image:width\" content=\"949\" \/>\n\t<meta property=\"og:image:height\" content=\"517\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot\",\"datePublished\":\"2020-06-23T06:35:00+00:00\",\"dateModified\":\"2020-06-23T07:12:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/\"},\"wordCount\":335,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/egyeni-datum1.jpg\",\"keywords\":[\"d\u00e1tum\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/\",\"name\":\"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/egyeni-datum1.jpg\",\"datePublished\":\"2020-06-23T06:35:00+00:00\",\"dateModified\":\"2020-06-23T07:12:33+00:00\",\"description\":\"Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa: Cellaform\u00e1z\u00e1s \\\/ Sz\u00e1m f\u00fcl \\\/ Egy\u00e9ni kateg\u00f3ri\u00e1n\u00e1l haszn\u00e1ld az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/egyeni-datum1.jpg\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/egyeni-datum1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/egyeni-datumformatum\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\\\/\\\/exceltitok.hu\\\/\",\"https:\\\/\\\/www.facebook.com\\\/bernadett.koros\"],\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/sos-excel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa: Cellaform\u00e1z\u00e1s \/ Sz\u00e1m f\u00fcl \/ Egy\u00e9ni kateg\u00f3ri\u00e1n\u00e1l haszn\u00e1ld az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/","og_locale":"hu_HU","og_type":"article","og_title":"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa: Cellaform\u00e1z\u00e1s \/ Sz\u00e1m f\u00fcl \/ Egy\u00e9ni kateg\u00f3ri\u00e1n\u00e1l haszn\u00e1ld az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket.","og_url":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2020-06-23T06:35:00+00:00","article_modified_time":"2020-06-23T07:12:33+00:00","og_image":[{"width":949,"height":517,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot","datePublished":"2020-06-23T06:35:00+00:00","dateModified":"2020-06-23T07:12:33+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/"},"wordCount":335,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/egyeni-datum1.jpg","keywords":["d\u00e1tum"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/","url":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/","name":"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/egyeni-datum1.jpg","datePublished":"2020-06-23T06:35:00+00:00","dateModified":"2020-06-23T07:12:33+00:00","description":"Egy\u00e9ni d\u00e1tumform\u00e1tum megad\u00e1sa: Cellaform\u00e1z\u00e1s \/ Sz\u00e1m f\u00fcl \/ Egy\u00e9ni kateg\u00f3ri\u00e1n\u00e1l haszn\u00e1ld az \u00e9 (mint \u00e9v), h (mint h\u00f3nap), \u00e9s n (mint nap) r\u00f6vid\u00edt\u00e9seket.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/egyeni-datum1.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/egyeni-datum1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Nem tal\u00e1lok megfelel\u0151 d\u00e1tum form\u00e1tumot"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=383"}],"version-history":[{"count":22,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/383\/revisions"}],"predecessor-version":[{"id":8801,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/383\/revisions\/8801"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}