{"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":"in-excel-what-does-it-mean","status":"publish","type":"post","link":"https:\/\/trucos.com\/en\/internet\/in-excel-what-does-it-mean\/","title":{"rendered":"#### in Excel \u2013 what it means"},"content":{"rendered":"<p>Let&#039;s see <strong>what does the code #### mean in Excel<\/strong>, an error code that usually appears in some Excel documents and that can cause confusion among users because they do not know its meaning or why it has appeared in an <a href=\"http:\/\/trucos.com\/en\/math\/how-to-remove-vat-from-a-price\/\" target=\"_blank\" rel=\"noopener\">random box<\/a>. And there are many <a href=\"http:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel users<\/a> they wonder <strong>what it means when #### appears in a cell<\/strong>; Don&#039;t fear, the matter is much simpler than it seems. Do not miss <strong>how to know what #### is in <a href=\"https:\/\/www.microsoft.com\/es-es\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> and how to fix it<\/strong>.<\/p>\n<div class=\"lyte-wrapper fourthree\" title=\"What is EXCEL and what is it used for? |Basic Concept (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\">What is EXCEL and what is it used for? |Basic Concept (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=\"What is EXCEL and what is it used for? |Basic Concept (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>What is #### in Excel and how to fix it<\/h2>\n<h3>Index of contents<\/h3>\n<ul>\n<li>\n<h3><a href=\"#que es\">What is the #### error in Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"#como corregir\">How to fix error #### in Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"#horas y fechas\">How to correct negative times or dates in Excel<\/a><\/h3>\n<\/li>\n<\/ul>\n<h2><a id=\"que es\" name=\"que es\"><span style=\"color:#000000\">What is the #### error in Excel<\/span><\/a><\/h2>\n<p>He <strong>error #### in Excel<\/strong> It is more common than it seems, since many users find cells in their documents with these types of symbols. In Microsoft Excel the code #### may appear in a cell if <strong>the column it is displayed in is not wide enough to show all its contents<\/strong>.<\/p>\n<p>On the other hand, the error code #### may indicate <strong>formulas that result in dates and times with negative values<\/strong>.<\/p>\n<p>Now you know <strong>what does Excel error #### mean<\/strong>, but does it have a solution? Read on to try the following solutions.<\/p>\n<h2><a id=\"como corregir\" name=\"como corregir\"><span style=\"color:#000000\">How to fix error #### in Excel<\/span><\/a><\/h2>\n<p>If this code appears in an Excel cell, the first thing we can try is <strong>expand the column width to show all the contents of its cell<\/strong>. To do this, do <strong>double click on the right edge of the column header<\/strong> either <strong>drag the column line to extend to the desired width<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"#### in Excel \u2013 what it means\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-01.jpg\" style=\"width:100%\" title=\"#### in Excel \u2013 what it means\" \/><\/p>\n<p>Another method we can try is <strong>reduce cell content<\/strong>. To do this, click <strong>Start<\/strong> and in the section <strong>Alignment<\/strong> activate the box <strong>Reduce until fit<\/strong> from the section <strong>text control<\/strong>. So you can adjust in the dialog box <strong>Cell format<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"#### in Excel \u2013 what it means\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-02.jpg\" style=\"width:100%\" title=\"#### in Excel \u2013 what it means\" \/><\/p>\n<p>On the other hand, if the cell affected by said error contains too many <a href=\"http:\/\/trucos.com\/en\/math\/how-to-convert-from-decimal-to-hexadecimal\/\" target=\"_blank\" rel=\"noopener\">decimal figures<\/a>, you can go to <strong>Start<\/strong> and select the option <strong>Decrease decimals<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"#### in Excel \u2013 what it means\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-03.jpg\" style=\"width:100%\" title=\"#### in Excel \u2013 what it means\" \/><\/p>\n<p>Finally, if the dates are too long, we can adjust them to display <a href=\"http:\/\/trucos.com\/en\/computers\/how-to-know-the-inches-of-a-laptop\/\" target=\"_blank\" rel=\"noopener\">correctly<\/a> in its corresponding cell. To do this, click <strong>Start<\/strong> and click on the arrow next to <strong>Number format<\/strong> to choose the option <strong>short date<\/strong>. In this way it is possible that a date that is too long is displayed in short format in the space of its cell.<\/p>\n<p><img decoding=\"async\" alt=\"#### in Excel \u2013 what it means\" src=\"\/media\/upload\/2022\/01\/24\/excel-error-04.jpg\" style=\"width:100%\" title=\"#### in Excel \u2013 what it means\" \/><\/p>\n<h2><a id=\"horas y fechas\" name=\"horas y fechas\"><span style=\"color:#000000\">How to correct negative times or dates in Excel<\/span><\/a><\/h2>\n<p>In the event that an Excel cell that shows the <strong>error code ####<\/strong> because it has a <strong>negative time or date value<\/strong>, you can do the following to try to correct it:<\/p>\n<ul>\n<li>Check the dates and times so they are displayed on <strong>positive values<\/strong> if using the 1900 date system.<\/li>\n<li>Use a formula to <strong>subtract dates<\/strong> for example <strong>=DATE.E(&quot;15\/15\/19&quot;;-5)<\/strong> either <strong>Add or subtract time<\/strong> such as =<strong>B2+B3<\/strong> correctly to avoid negative date or time value results.<\/li>\n<li>Change the negative results of the formula that has date or time format to another number format via <strong>Start<\/strong> &#8211; <strong>Number<\/strong>.<\/li>\n<\/ul>\n<p>Now you know <strong>What is Excel error #### and how to fix it<\/strong> through different methods depending on the origin of the problem.<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=EeaBuVwAz_g\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" alt=\"#### in Excel \u2013 what it means\" src=\"\/media\/upload\/2022\/01\/24\/yt_rVGj40I.jpg\" style=\"width:100%\" title=\"#### in Excel \u2013 what it means\" \/><\/a><\/p>\n<h2>More calculation tricks<\/h2>\n<ul>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/math\/how-to-get-percentages-in-excel\/\" target=\"_blank\" rel=\"noopener\">How to get percentages in Excel<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/math\/how-to-remove-vat-from-a-price\/\" target=\"_blank\" rel=\"noopener\">How to remove VAT from a price<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/math\/how-to-convert-from-decimal-to-hexadecimal\/\" target=\"_blank\" rel=\"noopener\">How to go from decimal to hexadecimal<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"http:\/\/trucos.com\/en\/computers\/how-to-know-the-inches-of-a-laptop\/\" target=\"_blank\" rel=\"noopener\">How to know the inches of a laptop<\/a><\/h3>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Has this strange symbol appeared in an Excel document? Do not worry; We show you what the ### error means and how to easily fix it<\/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 v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\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\/en\/internet\/in-excel-what-does-it-mean\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\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\/en\/internet\/in-excel-what-does-it-mean\/\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Redaccion\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"#### en Excel: qu\u00e9 significa - Trucos.com","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","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\/en\/internet\/in-excel-what-does-it-mean\/","og_locale":"en_GB","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\/en\/internet\/in-excel-what-does-it-mean\/","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":{"Written by":"Redaccion","Estimated reading time":"3 minutes"},"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":"en-GB"},{"@type":"WebPage","@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/","url":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/","name":"#### en Excel: qu\u00e9 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":"\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","breadcrumb":{"@id":"https:\/\/trucos.com\/internet\/en-excel-que-significa\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trucos.com\/internet\/en-excel-que-significa\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@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":"Los mejores trucos sobre videojuegos, tecnolog\u00eda y m\u00f3viles","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":"en-GB"},{"@type":"Organization","@id":"https:\/\/trucos.com\/#organization","name":"Trucos.com","url":"https:\/\/trucos.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@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":"Redaccion","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/trucos.com\/#\/schema\/person\/image\/","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\/en\/author\/redaccion\/"}]}},"_links":{"self":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/posts\/2843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/comments?post=2843"}],"version-history":[{"count":0,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/posts\/2843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/media\/2844"}],"wp:attachment":[{"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/media?parent=2843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/categories?post=2843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trucos.com\/en\/wp-json\/wp\/v2\/tags?post=2843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}