{"id":2843,"date":"2022-01-24T18:47:36","date_gmt":"2022-01-24T18:47:36","guid":{"rendered":"http:\/\/trucos.com\/uncategorized\/en-excel-que-significa\/"},"modified":"2022-01-24T18:47:36","modified_gmt":"2022-01-24T18:47:36","slug":"en-excel-que-significa","status":"publish","type":"post","link":"https:\/\/trucos.com\/ca\/internet\/en-excel-que-significa\/","title":{"rendered":"#### a Excel: qu\u00e8 significa"},"content":{"rendered":"<p>Vegem <strong>qu\u00e8 significa el codi #### a Excel<\/strong>, un codi d&#039;error que sol apar\u00e8ixer en alguns documents d&#039;Excel i que pot causar confusi\u00f3 entre els usuaris per no saber-ne el significat o per qu\u00e8 ha aparegut en una <a href=\"http:\/\/trucos.com\/ca\/matematiques\/com-treure-liva-a-un-preu\/\" target=\"_blank\" rel=\"noopener\">casella de forma alet\u00f2ria<\/a>. I \u00e9s que s\u00f3n molts els <a href=\"http:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/\" target=\"_blank\" rel=\"noopener\">usuaris d&#039;Excel<\/a> que es pregunten <strong>qu\u00e8 significa quan apareix #### en una cel\u00b7la<\/strong>; no tinguis por, l&#039;assumpte \u00e9s molt m\u00e9s senzill del que sembla. No et perdis <strong>com saber qu\u00e8 \u00e9s #### a <a href=\"https:\/\/www.microsoft.com\/es-es\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> i com solucionar-ho<\/strong>.<\/p>\n<div class=\"lyte-wrapper fourthree\" title=\"Qu\u00e8 \u00e9s EXCEL i Per qu\u00e8 SERVEIX? |Concepte B\u00e0sic (TUTORIAL 2021) \u2705\" style=\"width:420px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_BDTdmPV6fLg\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/i.ytimg.com\/vi\/BDTdmPV6fLg\/hqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/BDTdmPV6fLg\" \/><meta itemprop=\"duration\" content=\"PT2M38S\" \/><meta itemprop=\"uploadDate\" content=\"2021-04-13T13:32:57Z\" \/><\/div><div id=\"lyte_BDTdmPV6fLg\" data-src=\"https:\/\/i.ytimg.com\/vi\/BDTdmPV6fLg\/hqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">Qu\u00e8 \u00e9s EXCEL i Per qu\u00e8 SERVEIX? |Concepte B\u00e0sic (TUTORIAL 2021) \u2705<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/BDTdmPV6fLg\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi\/BDTdmPV6fLg\/0.jpg\" alt=\"Qu\u00e8 \u00e9s EXCEL i Per qu\u00e8 SERVEIX? |Concepte B\u00e0sic (TUTORIAL 2021) \u2705\" width=\"420\" height=\"295\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"TUTORIAL \u00bfQu\u00e9 es EXCEL y Para qu\u00e9 sirve? Es un curso b\u00e1sico de Microsoft Excel en computacion e inform\u00e1tica.\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:420px;margin:5px auto;\"><\/div><\/p>\n<h2>Qu\u00e8 \u00e9s #### a Excel i com solucionar-ho<\/h2>\n<h3>\u00cdndex de continguts<\/h3>\n<ul>\n<li>\n<h3><a href=\"#que es\">Qu\u00e8 \u00e9s lerror #### en Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"#como corregir\">Com corregir l&#039;error #### a Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"#horas y fechas\">Com corregir hores o dates negatives a Excel<\/a><\/h3>\n<\/li>\n<\/ul>\n<h2><a id=\"que es\" name=\"que es\"><span style=\"color:#000000\">Qu\u00e8 \u00e9s lerror #### en Excel<\/span><\/a><\/h2>\n<p>El <strong>error #### a Excel<\/strong> \u00e9s m\u00e9s com\u00fa del que sembla, ja que molts usuaris es troben amb cel\u00b7les dels documents amb aquest tipus de s\u00edmbols. A Microsoft Excel podeu apar\u00e8ixer el codi #### en una cel\u00b7la si <strong>la columna en qu\u00e8 es mostra no \u00e9s prou ampla per mostrar-ne tot el contingut<\/strong>.<\/p>\n<p>D&#039;altra banda, el codi d&#039;error #### podeu indicar <strong>f\u00f3rmules que resulten en dates i hores amb valors negatius<\/strong>.<\/p>\n<p>Ara ja saps <strong>qu\u00e8 significa l&#039;error #### d&#039;Excel<\/strong>, per\u00f2 t\u00e9 soluci\u00f3? Continua llegint per provar les solucions seg\u00fcents.<\/p>\n<h2><a id=\"como corregir\" name=\"como corregir\"><span style=\"color:#000000\">Com corregir l&#039;error #### a Excel<\/span><\/a><\/h2>\n<p>Si apareix aquest codi en una cel\u00b7la d&#039;Excel, el primer que podem intentar \u00e9s <strong>ampliar l&#039;amplada de la columna per mostrar tot el contingut de la cel\u00b7la<\/strong>. Per fer-ho, fes <strong>doble clic a la vora dreta de la cap\u00e7alera de columna<\/strong> o <strong>arrossega la l\u00ednia de la columna a ampliar fins a l&#039;amplada desitjada<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"#### a Excel: qu\u00e8 significa\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-01.jpg\" style=\"width:100%\" title=\"#### a Excel: qu\u00e8 significa\" \/><\/p>\n<p>Un altre m\u00e8tode que podem provar \u00e9s <strong>reduir el contingut de la cel\u00b7la<\/strong>. Per fer-ho, fes clic a <strong>Inici<\/strong> ia l&#039;apartat <strong>Alineaci\u00f3<\/strong> activar la casella <strong>Reduir fins ajustar<\/strong> de la secci\u00f3 <strong>Control de text<\/strong>. Aix\u00ed podr\u00e0s ajustar al quadre de di\u00e0leg <strong>Format de cel\u00b7les<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"#### a Excel: qu\u00e8 significa\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-02.jpg\" style=\"width:100%\" title=\"#### a Excel: qu\u00e8 significa\" \/><\/p>\n<p>D&#039;altra banda, si la cel\u00b7la afectada per aquest error cont\u00e9 massa <a href=\"http:\/\/trucos.com\/ca\/matematiques\/com-passar-de-decimal-a-hexadecimal\/\" target=\"_blank\" rel=\"noopener\">xifres decimals<\/a>, pots adre\u00e7ar-te a <strong>Inici<\/strong> i seleccionar l&#039;opci\u00f3 <strong>Disminuir decimals<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"#### a Excel: qu\u00e8 significa\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-03.jpg\" style=\"width:100%\" title=\"#### a Excel: qu\u00e8 significa\" \/><\/p>\n<p>Finalment, si les dates s\u00f3n massa llargues, podem ajustar-les perqu\u00e8 es mostrin <a href=\"http:\/\/trucos.com\/ca\/ordinadors\/com-saber-les-polzades-dun-portatil\/\" target=\"_blank\" rel=\"noopener\">correctament<\/a> a la cel\u00b7la corresponent. Per fer-ho, fes clic a <strong>Inici<\/strong> i prem sobre la fletxa al costat de <strong>Format de n\u00famero<\/strong> per triar l&#039;opci\u00f3 <strong>Data curta<\/strong>. D&#039;aquesta manera \u00e9s possible que una data massa llarga es mostri en format curt a l&#039;espai de la cel\u00b7la.<\/p>\n<p><img decoding=\"async\" alt=\"#### a Excel: qu\u00e8 significa\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-04.jpg\" style=\"width:100%\" title=\"#### a Excel: qu\u00e8 significa\" \/><\/p>\n<h2><a id=\"horas y fechas\" name=\"horas y fechas\"><span style=\"color:#000000\">Com corregir hores o dates negatives a Excel<\/span><\/a><\/h2>\n<p>En cas que una cel\u00b7la d&#039;Excel que mostri el <strong>codi d&#039;error ####<\/strong> perqu\u00e8 t\u00e9 un <strong>valor d&#039;hora o data negatiu<\/strong>, pots realitzar el seg\u00fcent per intentar corregir-ho:<\/p>\n<ul>\n<li>Revisa les dates i les hores perqu\u00e8 es mostrin a <strong>valors positius<\/strong> si es fa servir el sistema de dates 1900.<\/li>\n<li>Fes servir una f\u00f3rmula per <strong>restar dates<\/strong> com per exemple <strong>=DA.E(&quot;15\/15\/19&quot;;-5)<\/strong> o <strong>Sumar o restar temps<\/strong> com per exemple =<strong>B2+B3<\/strong> correctament per evitar resultats negatius de valor de data o hora.<\/li>\n<li>Canvia els resultats negatiu de la f\u00f3rmula que t\u00e9 format de data o hora a un altre format de n\u00famero a trav\u00e9s de <strong>Inici<\/strong> &#8211; <strong>N\u00famero<\/strong>.<\/li>\n<\/ul>\n<p>Ara ja saps <strong>qu\u00e8 \u00e9s l&#039;error #### d&#039;Excel i com solucionar-ho<\/strong> mitjan\u00e7ant diferents m\u00e8todes segons l&#039;origen del problema.<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=EeaBuVwAz_g\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" alt=\"#### a Excel: qu\u00e8 significa\" src=\"\/media\/upload\/2022\/01\/24\/yt_rVGj40I.jpg\" style=\"width:100%\" title=\"#### a Excel: qu\u00e8 significa\" \/><\/a><\/p>\n<h2>M\u00e9s trucs sobre c\u00e0lcul<\/h2>\n<ul>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/ca\/matematiques\/com-treure-percentatges-en-excel\/\" target=\"_blank\" rel=\"noopener\">Com treure percentatges a Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/ca\/matematiques\/com-treure-liva-a-un-preu\/\" target=\"_blank\" rel=\"noopener\">Com treure l&#039;IVA a un preu<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/ca\/matematiques\/com-passar-de-decimal-a-hexadecimal\/\" target=\"_blank\" rel=\"noopener\">Com passar de decimal a hexadecimal<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/ca\/ordinadors\/com-saber-les-polzades-dun-portatil\/\" target=\"_blank\" rel=\"noopener\">Com saber les polzades dun port\u00e0til<\/a><\/h3>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Heu aparegut aquest s\u00edmbol tan estrany en un document d&#039;Excel? No tinguis por; t&#039;ensenyem qu\u00e8 significa l&#039;error ### i com solucionar-ho f\u00e0cilment<\/p>","protected":false},"author":2,"featured_media":2844,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[19],"class_list":["post-2843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-internet","tag-tecnologia"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>#### en Excel: qu\u00e9 significa - Trucos.com<\/title>\n<meta name=\"description\" content=\"\u00bfHa aparecido este s\u00edmbolo tan extra\u00f1o en un documento de Excel? No temas; te ense\u00f1amos qu\u00e9 significa el error ### y c\u00f3mo solucionarlo f\u00e1cilmente\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trucos.com\/ca\/internet\/en-excel-que-significa\/\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"#### en Excel: qu\u00e9 significa - Trucos.com\" \/>\n<meta property=\"og:description\" content=\"\u00bfHa aparecido este s\u00edmbolo tan extra\u00f1o en un documento de Excel? No temas; te ense\u00f1amos qu\u00e9 significa el error ### y c\u00f3mo solucionarlo f\u00e1cilmente\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trucos.com\/ca\/internet\/en-excel-que-significa\/\" \/>\n<meta property=\"og:site_name\" content=\"Trucos.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/trucoscom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-24T18:47:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/excel_error_00.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"666\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Redaccion\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrit per\" \/>\n\t<meta name=\"twitter:data1\" content=\"Redaccion\" \/>\n\t<meta name=\"twitter:label2\" content=\"Temps estimat de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuts\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"#### a Excel: qu\u00e8 significa - Trucos.com","description":"Heu aparegut aquest s\u00edmbol tan estrany en un document d&#039;Excel? No tinguis por; t&#039;ensenyem qu\u00e8 significa l&#039;error ### i com solucionar-ho f\u00e0cilment","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:\/\/trucos.com\/ca\/internet\/en-excel-que-significa\/","og_locale":"ca_ES","og_type":"article","og_title":"#### en Excel: qu\u00e9 significa - Trucos.com","og_description":"\u00bfHa aparecido este s\u00edmbolo tan extra\u00f1o en un documento de Excel? No temas; te ense\u00f1amos qu\u00e9 significa el error ### y c\u00f3mo solucionarlo f\u00e1cilmente","og_url":"https:\/\/trucos.com\/ca\/internet\/en-excel-que-significa\/","og_site_name":"Trucos.com","article_publisher":"https:\/\/www.facebook.com\/trucoscom\/","article_published_time":"2022-01-24T18:47:36+00:00","og_image":[{"width":800,"height":666,"url":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/excel_error_00.jpg","type":"image\/jpeg"}],"author":"Redaccion","twitter_card":"summary_large_image","twitter_misc":{"Escrit per":"Redaccion","Temps estimat de lectura":"3 minuts"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#article","isPartOf":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/"},"author":{"name":"Redaccion","@id":"https:\/\/trucos.com\/#\/schema\/person\/a435f425aecd84e1df6f98ccee7ce536"},"headline":"#### en Excel: qu\u00e9 significa","datePublished":"2022-01-24T18:47:36+00:00","mainEntityOfPage":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/"},"wordCount":686,"publisher":{"@id":"https:\/\/trucos.com\/#organization"},"image":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#primaryimage"},"thumbnailUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/excel_error_00.jpg","keywords":["Tecnologia"],"articleSection":["Internet"],"inLanguage":"ca"},{"@type":"WebPage","@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/","url":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/","name":"#### a Excel: qu\u00e8 significa - Trucos.com","isPartOf":{"@id":"https:\/\/trucos.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#primaryimage"},"image":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#primaryimage"},"thumbnailUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/excel_error_00.jpg","datePublished":"2022-01-24T18:47:36+00:00","description":"Heu aparegut aquest s\u00edmbol tan estrany en un document d&#039;Excel? No tinguis por; t&#039;ensenyem qu\u00e8 significa l&#039;error ### i com solucionar-ho f\u00e0cilment","breadcrumb":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trucos.com\/internet\/en-excel-que-significa\/"]}]},{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#primaryimage","url":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/excel_error_00.jpg","contentUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/excel_error_00.jpg","width":800,"height":666},{"@type":"BreadcrumbList","@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trucos.com\/"},{"@type":"ListItem","position":2,"name":"#### en Excel: qu\u00e9 significa"}]},{"@type":"WebSite","@id":"https:\/\/trucos.com\/#website","url":"https:\/\/trucos.com\/","name":"Trucos.com","description":"Els millors trucs sobre videojocs, tecnologia i m\u00f2bils","publisher":{"@id":"https:\/\/trucos.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trucos.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"},{"@type":"Organization","@id":"https:\/\/trucos.com\/#organization","name":"Trucos.com","url":"https:\/\/trucos.com\/","logo":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/trucos.com\/#\/schema\/logo\/image\/","url":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/trucoscomlogo.png","contentUrl":"https:\/\/trucos.com\/wp-content\/uploads\/2023\/06\/trucoscomlogo.png","width":207,"height":68,"caption":"Trucos.com"},"image":{"@id":"https:\/\/trucos.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/trucoscom\/"]},{"@type":"Person","@id":"https:\/\/trucos.com\/#\/schema\/person\/a435f425aecd84e1df6f98ccee7ce536","name":"Redacci\u00f3","image":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/secure.gravatar.com\/avatar\/d9294dcdc49d94ba92a2933c1c65d27c01fed9c237bbd5f6c305ee54ff52f55b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d9294dcdc49d94ba92a2933c1c65d27c01fed9c237bbd5f6c305ee54ff52f55b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d9294dcdc49d94ba92a2933c1c65d27c01fed9c237bbd5f6c305ee54ff52f55b?s=96&d=mm&r=g","caption":"Redaccion"},"sameAs":["http:\/\/trucos.com"],"url":"https:\/\/trucos.com\/ca\/author\/redaccion\/"}]}},"_links":{"self":[{"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/posts\/2843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/comments?post=2843"}],"version-history":[{"count":0,"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/posts\/2843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/media\/2844"}],"wp:attachment":[{"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/media?parent=2843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/categories?post=2843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trucos.com\/ca\/wp-json\/wp\/v2\/tags?post=2843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}