<div>
Wonderful! &nbsp;I tried both the Input translation and Input validation formulas which you provided, and they are perfect for what I wished to accomplish. &nbsp; Thank you so much.
</div>


Wonderful!  I tried both the Input translation and Input validation formulas which you provided, and they are perfect for what I wished to accomplish.   Thank you so much.

<div>
tahk you for the points and for the feedback &lt;|;-)
</div>


tahk you for the points and for the feedback <|;-)

<div>
<div class="content wysiwyg-content">
In Lotus Notes R5 designer, we have a field that is defined as text, editable. &nbsp;It represents a number. &nbsp;We want it to be a full 8 characters, and if the user keys in less than 8 characters, we want to pad it automatically on the left with zeros. &nbsp;Example: if user keys 12345, we want to automatically make it to be 00012345. &nbsp; <br />
<br />
What is the Formula Language (@...) command to pad left with zeros to a specific number of total characters?
</div>
</div>


In Lotus Notes R5 designer, we have a field that is defined as text, editable.  It represents a number.  We want it to be a full 8 characters, and if the user keys in less than 8 characters, we want to pad it automatically on the left with zeros.  Example: if user keys 12345, we want to automatically make it to be 00012345.   

What is the Formula Language (@...) command to pad left with zeros to a specific number of total characters?

Pad Left with Zeros in Formula Language

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.