{"id":11943,"date":"2022-10-13T08:22:54","date_gmt":"2022-10-13T08:22:54","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=11943"},"modified":"2024-03-28T11:19:41","modified_gmt":"2024-03-28T11:19:41","slug":"keep-leading-zeroes-in-excel-csv","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/","title":{"rendered":"Keep Leading Zeroes in Excel CSV"},"content":{"rendered":"\n
Keep-Leading-Zeroes-in-Excel-CSV<\/a>Download File<\/a><\/div>\n\n\n\n

By default, Excel removes leading zeroes from any real number you enter in a cell. This is because the zeroes are insignificant. Sometimes you may want to keep the leading zeroes as in the case of phone numbers, credit card numbers, product codes, and so on. This tutorial shows you how to keep leading zeroes in an Excel CSV file.<\/p>\n\n\n\n

How to Keep Leading Zeroes When Entering Data<\/h2>\n\n\n\n

We will use the following dataset in our examples:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

Method 1: Apply the Text Format Before Entering the Data<\/h3>\n\n\n\n

Suppose we want to enter product codes that have leading zeroes in the range B2:B4.<\/p>\n\n\n\n

We use the steps below:<\/p>\n\n\n\n

    \n
  1. Select range B2:B4.<\/li>\n<\/ol>\n\n\n\n
    \"Table\n\nDescription<\/figure>\n\n\n\n
      \n
    1. Right-click the selection and click Format Cells<\/strong> on the shortcut menu.<\/li>\n<\/ol>\n\n\n\n
      \"Graphical<\/figure>\n\n\n\n

      Note:<\/strong> You can also open the Format Cells<\/strong> dialog box by pressing Ctrl + 1<\/strong>.<\/p>\n\n\n\n

        \n
      1. In the Format Cells<\/strong> dialog box, select the Text<\/strong> category in the Number<\/strong> tab and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        The Text<\/strong> format is applied to the selection.<\/p>\n\n\n\n

        Note:<\/strong> You can also apply the Text format to the selection by clicking Home >> Number >> Number Format >> Text<\/strong>.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n
          \n
        1. Type in the product codes with leading zeroes.<\/li>\n<\/ol>\n\n\n\n
          \"Table\n\nDescription<\/figure>\n\n\n\n

          Excel does not remove the leading zeroes.<\/p>\n\n\n\n

          Method 2: Begin with the Apostrophe During Data Entry<\/h3>\n\n\n\n

          The fastest way to apply a Text format to a cell and keep the leading zeroes during data entry is to use an apostrophe.<\/p>\n\n\n\n

          We use the steps below:<\/p>\n\n\n\n

            \n
          1. Select cell B2.<\/li>\n\n\n\n
          2. First, insert an apostrophe (\u2018) and then type in the product code with leading zeroes.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. Press the Enter key on the keyboard or click the Enter button on the Formula Bar.<\/li>\n<\/ol>\n\n\n\n
              \"Table\n\nDescription<\/figure>\n\n\n\n
                \n
              1. Repeat steps 2 and 3 as you type in the other product codes.<\/li>\n<\/ol>\n\n\n\n
                \"Table\n\nDescription<\/figure>\n\n\n\n

                Method 3: Apply a Custom Number Format<\/h3>\n\n\n\n

                We use the following steps:<\/p>\n\n\n\n

                  \n
                1. Select range B2:B4.<\/li>\n\n\n\n
                2. Press Ctrl + 1<\/strong> to open the Format Cells<\/strong> dialog box.<\/li>\n\n\n\n
                3. In the Format Cells<\/strong> dialog box, select the Text<\/strong> category in the Number<\/strong> tab.<\/li>\n<\/ol>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n
                    \n
                  1. Delete the format that is in the Type<\/strong> text box on the right of the Category<\/strong> box and type the format \u201c000\u201d#<\/strong> in the box and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n

                    Note<\/strong>: The zeroes with double quotation marks(\u201c000\u201d) ensure that Excel keeps the leading three zeroes. The hash (#) mark defines any number of digits that you want to follow the leading zeroes.<\/p>\n\n\n\n

                    \"\"<\/figure>\n\n\n\n
                      \n
                    1. Type the product codes with leading zeroes in the range B2:B4.<\/li>\n<\/ol>\n\n\n\n
                      \"Table\n\nDescription<\/figure>\n\n\n\n

                      Excel does not remove the leading zeroes in the product codes.<\/p>\n\n\n\n

                      Method 4: Use the CONCATENATE Function<\/h3>\n\n\n\n

                      The CONCATENATE<\/strong> function joins several strings into a single string.<\/p>\n\n\n\n

                      We use the following dataset in illustrating this method:<\/p>\n\n\n\n

                      \"\"<\/figure>\n\n\n\n

                      We use the steps below:<\/p>\n\n\n\n

                        \n
                      1. Select cell C2 and type in the following formula:<\/li>\n<\/ol>\n\n\n\n

                        =CONCATENATE(“000”,B2)<\/p>\n\n\n\n

                        \"\"<\/figure>\n\n\n\n
                          \n
                        1. Press Enter on the keyboard or click the Enter button on the Formula Bar.<\/li>\n<\/ol>\n\n\n\n
                          \"Table\n\nDescription<\/figure>\n\n\n\n
                            \n
                          1. Double-click or drag down the fill handle to copy the formula down<\/a> the column.<\/li>\n<\/ol>\n\n\n\n
                            \"\"<\/figure>\n\n\n\n

                            Method 5: Use Hyphens in Between Numbers<\/h3>\n\n\n\n

                            We use the following dataset in our example:<\/p>\n\n\n\n

                            \"\"<\/figure>\n\n\n\n

                            We use the steps below:<\/p>\n\n\n\n

                              \n
                            1. Select cell B2 and type in the following product code:<\/li>\n<\/ol>\n\n\n\n

                              000-512<\/p>\n\n\n\n

                              \"Table\n\nDescription<\/figure>\n\n\n\n
                                \n
                              1. Type in the other product codes using the same pattern.<\/li>\n<\/ol>\n\n\n\n
                                \"Table\n\nDescription<\/figure>\n\n\n\n

                                How to Keep Leading Zeroes When Importing Data<\/h2>\n\n\n\n

                                Suppose you want to import data that has leading zeroes into your Excel CSV file. You can use Power Query<\/strong> to convert numbers to text<\/a> when you import the data.<\/p>\n\n\n\n

                                We use the following steps:<\/p>\n\n\n\n

                                  \n
                                1. Click Data >> Get & Transform Data >> Get Data >> From File >> From Text\/CSV<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                                  \"\"<\/figure>\n\n\n\n
                                    \n
                                  1. Navigate to where the Text\/CSV file is stored. Select it and click Import.<\/li>\n<\/ol>\n\n\n\n
                                    \"Graphical<\/figure>\n\n\n\n
                                      \n
                                    1. Click the Transform Data<\/strong> button at the bottom of the Power Query<\/strong> window to load the Query Editor<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                                      \"Graphical<\/figure>\n\n\n\n
                                        \n
                                      1. Click on the column header of the Product Code column to select the column.<\/li>\n<\/ol>\n\n\n\n
                                        \"Graphical<\/figure>\n\n\n\n
                                          \n
                                        1. Click Home >> Transform >> Data Type >> Text<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                                          \"\"<\/figure>\n\n\n\n
                                            \n
                                          1. Click the Replace Current<\/strong> button in the Change Column Type<\/strong> dialog box that appears.<\/li>\n<\/ol>\n\n\n\n
                                            \"\"<\/figure>\n\n\n\n

                                            The data in the column is changed to text and the leading zeroes appear.<\/p>\n\n\n\n

                                            \"Graphical<\/figure>\n\n\n\n
                                              \n
                                            1. Click the Close & Load<\/strong> button to finish the importation process.<\/li>\n<\/ol>\n\n\n\n
                                              \"Graphical<\/figure>\n\n\n\n

                                              The data is imported into the worksheet in form of a table.<\/p>\n\n\n\n

                                              \"\"<\/figure>\n\n\n\n

                                              Conclusion<\/h2>\n\n\n\n

                                              Excel by default removes leading zeroes from any real number you enter in a cell because the zeroes are insignificant. Sometimes however you may want to keep the leading zeroes. This tutorial looked at six methods that one can use to keep the leading zeroes in an Excel CSV file.<\/p>\n","protected":false},"excerpt":{"rendered":"

                                              By default, Excel removes leading zeroes from any real number you enter in a cell. This is because the zeroes are insignificant. Sometimes…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nKeep Leading Zeroes in Excel CSV<\/title>\n<meta name=\"description\" content=\"Learn how to keep leading zeroes in an Excel CSV file. Follow our step-by-step guide to ensure your data maintains accuracy. Download the file now.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Keep Leading Zeroes in Excel CSV\" \/>\n<meta property=\"og:description\" content=\"Learn how to keep leading zeroes in an Excel CSV file. Follow our step-by-step guide to ensure your data maintains accuracy. Download the file now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-13T08:22:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T11:19:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Keep Leading Zeroes in Excel CSV\",\"datePublished\":\"2022-10-13T08:22:54+00:00\",\"dateModified\":\"2024-03-28T11:19:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\"},\"wordCount\":740,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\",\"name\":\"Keep Leading Zeroes in Excel CSV\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png\",\"datePublished\":\"2022-10-13T08:22:54+00:00\",\"dateModified\":\"2024-03-28T11:19:41+00:00\",\"description\":\"Learn how to keep leading zeroes in an Excel CSV file. Follow our step-by-step guide to ensure your data maintains accuracy. Download the file now.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Keep Leading Zeroes in Excel CSV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Keep Leading Zeroes in Excel CSV","description":"Learn how to keep leading zeroes in an Excel CSV file. Follow our step-by-step guide to ensure your data maintains accuracy. Download the file now.","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:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/","og_locale":"en_US","og_type":"article","og_title":"Keep Leading Zeroes in Excel CSV","og_description":"Learn how to keep leading zeroes in an Excel CSV file. Follow our step-by-step guide to ensure your data maintains accuracy. Download the file now.","og_url":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/","article_published_time":"2022-10-13T08:22:54+00:00","article_modified_time":"2024-03-28T11:19:41+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Keep Leading Zeroes in Excel CSV","datePublished":"2022-10-13T08:22:54+00:00","dateModified":"2024-03-28T11:19:41+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/"},"wordCount":740,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/","url":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/","name":"Keep Leading Zeroes in Excel CSV","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png","datePublished":"2022-10-13T08:22:54+00:00","dateModified":"2024-03-28T11:19:41+00:00","description":"Learn how to keep leading zeroes in an Excel CSV file. Follow our step-by-step guide to ensure your data maintains accuracy. Download the file now.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/10\/table-description-automatically-generated-9.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Keep Leading Zeroes in Excel CSV"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11943"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=11943"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11943\/revisions"}],"predecessor-version":[{"id":15783,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11943\/revisions\/15783"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=11943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=11943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=11943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}