Excell - zeros in front of the number

Posted on 2011-05-02
Last Modified: 2012-05-11
Quick question - can should I format the cells to it accepptsw zeros in front of the number?  No matter what I try it remove 0's and leaves just a number...  Drives me crazy
Please advice.
Question by:Tiras25
    LVL 92

    Expert Comment

    by:Patrick Matthews
    Depends on how many digits you want.  To always display, say, 5 digits, with leading zeroes if need be, use a customer number format of:

    LVL 92

    Accepted Solution

    Make that "To always display, say, at least 5 digits, ..."
    LVL 17

    Author Comment

    Custom format.  Got it.   Is there a way to tell excell to accept whatever numbers you typing without ANY modifications?
    LVL 59

    Assisted Solution

    by:Chris Bottomley
    Use the tick mark <<< ` >>> , top left of the keyboard at the start of what you type

    LVL 17

    Author Comment

    Perfect.  Thanks!!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This article will show you how to use shortcut menus in the Access run-time environment.
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now