{"id":362,"date":"2010-12-09T23:57:51","date_gmt":"2010-12-09T22:57:51","guid":{"rendered":"http:\/\/www.matjazev.net\/blog\/?p=362"},"modified":"2010-12-17T14:26:58","modified_gmt":"2010-12-17T13:26:58","slug":"oblikovanje-celic-v-excelu-%e2%80%93-numericne-kode","status":"publish","type":"post","link":"https:\/\/www.matjazev.net\/blog\/2010\/12\/09\/oblikovanje-celic-v-excelu-%e2%80%93-numericne-kode\/","title":{"rendered":"Oblikovanje celic v Excelu \u2013 numeri\u010dne kode"},"content":{"rendered":"<p>Kot sem omenil \u017ee ve\u010dkrat, <strong>pozna Excel samo \u0161tevilke in \u010drke oz. besede<\/strong>. In v odvisnosti od oblike lahko neko \u0161tevilko prika\u017eemo kot \u0161tevilo, kot procent, kot datum ali kot\u2026<\/p>\n<p>Excel ima mnogo vnaprej pripravljenih oblik celic (formatov) in ti resni\u010dno zado\u0161\u010dajo za ve\u010dino potreb, a v\u010dasih bi \u017eeleli kaj posebnega in v teh primerih moramo pa\u010d pose\u010di po lastni obliki celic.<\/p>\n<p>V pri\u010dujo\u010dem blogu vam bom predstavil kako lahko v Excelu oblikujete \u0161tevilke, \u010dez dan ali dva pa bom prikazal \u0161e oblikovanje:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.matjazev.net\/blog\/2010\/12\/12\/oblikovanje-celic-v-excelu-kode-za-tekst\/\">teksta<\/a><\/li>\n<li><a href=\"http:\/\/www.matjazev.net\/blog\/2010\/12\/17\/oblikovanje-celic-v-excelu-kode-za-datum-in-cas\/\">datumov, \u010dasov<\/a><\/li>\n<li>in prav posebne kode (uporaba slednjih pa je \u017ee mnogo let dokaj nesmiselna, saj jih je zamenjalo pogojno oblikovanje!)<\/li>\n<\/ul>\n<h3>Kako do lastne oblike celic<\/h3>\n<p>V verzijah Excelov pred 2007 izberete menijsko opcijo <strong>Oblika\/Celice<\/strong>, v Excelu 2007 in novej\u0161ih pa na zavihku <strong>Osnovno <\/strong>samo raz\u0161irite okvir\u010dek <strong>\u0160tevilo<\/strong>:<br \/>\n<a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_path.gif\"><\/a><\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_path.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-371\" title=\"cell_format_path\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_path.gif\" alt=\"\" width=\"359\" height=\"146\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_path.gif 359w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_path-300x122.gif 300w\" sizes=\"(max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_path.gif\"><br \/>\n<\/a> V vsakem primeru se vam prika\u017ee isto okno:<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_dialog.gif\"><\/a><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_dialog.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-370\" title=\"cell_format_dialog\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_dialog-300x267.gif\" alt=\"\" width=\"300\" height=\"267\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_dialog-300x267.gif 300w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/cell_format_dialog.gif 517w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>V prikazanem oknu izberete opcijo &#8216;<strong>Po meri<\/strong>&#8216; in vnesete novo obliko celic<\/p>\n<h3>Osnovna oblika<\/h3>\n<p><strong>Excel lo\u010di 4 oblike:<\/strong> <em>obliko za pozitivna \u0161tevila, obliko za negativna \u0161tevila, obliko ni\u010del in obliko teksta<\/em>. Ker je vse skupaj potrebno zapisati v eno vrstico, Excel posamezne elemente lo\u010di s podpi\u010djem:<br \/>\n<pre>[pozitivna \u0161t.];[negativna \u0161t.];[ni\u010dle];[besedilo]<\/pre><\/p>\n<h3>Oblikovni znaki za \u0161tevila<\/h3>\n<p>Tabela oblikovnih znakov za \u0161tevila:<\/p>\n<table cellspacing=\"5\" cellpadding=\"5\" frame=\"box\">\n<tbody>\n<tr>\n<th>Znak<\/th>\n<th>Pomen<\/th>\n<\/tr>\n<tr>\n<td><strong>0 (ni\u010dla)<\/strong><\/td>\n<td>Ograda za cifro. \u010ce na tem mestu ni cifre se izpi\u0161e 0<\/td>\n<\/tr>\n<tr>\n<td><strong>#<\/strong><\/td>\n<td>Ograda za cifro. \u010ce na tem mestu ni cifre se ne izpi\u0161e ni\u010d<\/td>\n<\/tr>\n<tr>\n<td><strong>?<\/strong><\/td>\n<td>Ograda za cifro. \u010ce na tem mestu ni cifre se izpi\u0161e presledek<\/td>\n<\/tr>\n<tr>\n<td><strong>. (pika)<\/strong><\/td>\n<td>Oznaka za decimalno vejico. Da res vejico ? &#8211; mora sicer biti pika, a v SLO Excelu se bo na tem mestu prikazala vejica<\/td>\n<\/tr>\n<tr>\n<td><strong>%<\/strong><\/td>\n<td>Odstotek. Excel pomno\u017ei \u0161tevilo s 100 in doda oznako za procent (%)<\/td>\n<\/tr>\n<tr>\n<td><strong>, (vejica)<\/strong><\/td>\n<td>Lo\u010dilo tiso\u010dic. Mora biti vejica, v SLO Excelu jo seveda nadomesti pika<\/td>\n<\/tr>\n<tr>\n<td><strong>E+ E- e+ e-<\/strong><\/td>\n<td>Oznaka za znanstveno notacijo.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Primeri<\/h3>\n<p>\u010cetudi se vseskupaj zdi zapleteno, pa bo skozi primere vidno, da je prav preprosto. <a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/oblika_celic.xls\">Nalo\u017eite si pripeto datoteko in se igrajte<\/a> &#8230; \ud83d\ude42<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/oblika_celic.xls\">&lt;datoteka s primeri&gt;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kot sem omenil \u017ee ve\u010dkrat, pozna Excel samo \u0161tevilke in \u010drke oz. besede. In v odvisnosti od oblike lahko neko \u0161tevilko prika\u017eemo kot \u0161tevilo, kot procent, kot datum ali kot\u2026 Excel ima mnogo vnaprej pripravljenih oblik celic (formatov) in ti resni\u010dno zado\u0161\u010dajo za ve\u010dino potreb, a v\u010dasih bi \u017eeleli kaj posebnega in v teh primerih &hellip; <a href=\"https:\/\/www.matjazev.net\/blog\/2010\/12\/09\/oblikovanje-celic-v-excelu-%e2%80%93-numericne-kode\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Oblikovanje celic v Excelu \u2013 numeri\u010dne kode<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,3,19],"tags":[14,9,61,33,22,30],"_links":{"self":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/362"}],"collection":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/comments?post=362"}],"version-history":[{"count":25,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/362\/revisions"}],"predecessor-version":[{"id":426,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/362\/revisions\/426"}],"wp:attachment":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/media?parent=362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/categories?post=362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/tags?post=362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}