<div>
Depends on how many digits you want. &nbsp;To always display, say, 5 digits, with leading zeroes if need be, use a customer number format of:<br />
<br />
00000
</div>


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:

00000

<div>
Custom format. &nbsp;Got it. &nbsp; Is there a way to tell excell to accept whatever numbers you typing without ANY modifications?
</div>


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

<div>
<div class="content wysiwyg-content">
Quick question - can should I format the cells to it accepptsw zeros in front of the number? &nbsp;No matter what I try it remove 0's and leaves just a number... &nbsp;Drives me crazy<br />
Please advice.
</div>
</div>


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.

Excell - zeros in front of the number

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Productivity software is application software dedicated to producing information, such as documents, presentations, worksheets, databases, charts, graphs, digital paintings, electronic music and digital video. Most common programs and suites such as Microsoft Office and LibreOffice have their own topics. Office suites, which brought word processing, spreadsheet, and relational database programs to the desktop in the 1980s, are the core example of productivity software, but they can include communications software, personal information managers, groupware and log analysis software.