Preceeding Zero's

[BROWNIE56]

I need to be able to display an account number that will always disply "zero's" before the account number, up to six digits.

Example:
000056
001112
023433
000001

Thank you,
Sharon

 

[Ngolem]

try this

Totext({table.AccountNum}),"000000&quot

that should work...please note that this format does not round numbers...rather it truncates them

Hope this helps
Jim