New Horizons Get Schooled Blog

Keep leading zeros in Excel

Posted on 9/30/13 2:18 PM by Get Schooled in Excel, in excel training, in Microsoft, in tips and tricks, in Tips & Tricks

If you need to enter the Zip code 02364 in your Excel spreadsheet, you'll probably throw your hands up when Excel automatically changes the value to 2364. Your Zip code must have five digits, but by default Excel doesn't display leading zeros.

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.

     

    Subscribe