• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

3 ways to enter data starting with 0 in Excel

0 Comments

3 ways to enter data starting with 0 in Excel: Entering data that starts with 0 is a common problem that many people face, especially accountants when inputting invoice numbers like 0001234. In this article, Buffcom.net will introduce you to 3 ways to enter data starting with 0 in Excel.

For example, when you enter 0001234 into an Excel cell, it will recognize it as a number and cut off the three leading zeros.

3 ways to enter data starting with 0 in

 

To solve this problem, you can follow these methods:

3 ways to enter data starting with 0 in1. Use Format Cells

To keep the leading zeros, right-click on the cell and select Format Cells.

3 ways to enter data starting with 0 inThen select Number => Custom and enter 7 zeros in the Type field. Since invoice numbers always have 7 digits, we need to enter 7 zeros in this case. Then click OK to complete.

3 ways to enter data starting with 0 in

 

Now, if you enter a number with fewer than 7 digits, Excel will automatically add zeros to the beginning to make it a 7-digit number.

 

3 ways to enter data starting with 0 in Excel

3 ways to enter data starting with 0 in Excel

2. Use Text format

3 ways to enter data starting with 0 in

 

To keep the leading zeros, go to the Home tab, select Format Number, and then select the Text format.Now, no matter how many leading zeros you enter, Excel will not cut them off.

3 ways to enter data starting with 0 in3. Use an apostrophe (‘) at the beginning

By using an apostrophe (‘) at the beginning, the leading zeros will be retained without being cut off. This method also applies to many other cases in Excel.

3 ways to enter data starting with 0 in Excel

3 ways to enter data starting with 0 in Excel

In conclusion, this article has introduced you to 3 ways to enter data starting with 0 in Excel. We hope it will be helpful for you in your work. Good luck!

Rate this post
36
273 Views
Quick tip to check the version of Excel you are usingPrevQuick tip to check the version of Excel you are usingApril 28, 2023
Quickly fix date format errors in ExcelApril 28, 2023Quickly fix date format errors in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
Products
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Project Standard 2021 Microsoft Project Standard 2021 - 1 PC $13.00
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
  • Windows Server 2019 Essentials Key Global Windows Server 2019 Essentials Key Global
    Rated 4.71 out of 5
    $7.00
  • Kaspersky Standard - 1 Device, 1 Year (Global License) Kaspersky Standard - 1 Device, 1 Year (Global License) $21.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.