Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Leading zeros (eg. 00054628)

Last updated: before December, 1998

To output data with leading zeros create and output a calculated field containing the formula:

Right(Combine('0000000',DB.NUMBER), 7)

where '7' is the maximum number of digets, and hence the length of the output string, and 0000000 is a line of zeros of the same length.

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.