Skip to main content

Introduction

Learn how to keep the leading zero when entering in data onto google sheets.

  1. Typing "google.com" in the address bar to go to the google website
    • Typing "google.com" in the address bar to go to the google website

  2. Click on the "Sign In" button to sign in your google account
    • Click on the "Sign In" button to sign in your google account

  3. Type your email address into this box
    • Type your email address into this box

    • Click on the blue "Next" button

  4. Type your password into this box
    • Type your password into this box

    • Click on the blue "Sign In" button

  5. Click this button to open a menu of options
    • Click this button to open a menu of options

    • Click on the "Sheet" button

  6. Click + button to create new spreadsheet
    • Click + button to create new spreadsheet

  7. Highlight the cells you are woking with and click the "Format" button
    • Highlight the cells you are woking with and click the "Format" button

    • Click on Numbers

    • Select "Plain Text"

  8. This Column shows how the numbers with a leading zero look like with a leading zero if you format the cells
    • This Column shows how the numbers with a leading zero look like with a leading zero if you format the cells

    • This column shows what the numbers with a leading zero look like if you do not format the cells

Finish Line

One other person completed this guide.

Aaron

Member since: 06/08/2015

1 Reputation

42 Guides authored

0 Comments

Add Comment

View Statistics:

Past 24 Hours: 0

Past 7 Days: 0

Past 30 Days: 0

All Time: 5