Custom Number Format

[Joe Troxtel]

This seams like it should be simple but for the life of me I can/t figure it out.

Problem- Short version... I am entering a "1" and I want to return 001. The filed is a number field with a general number format assigned to it.

In Excel you can specify custom number functions by using the ### which will return 001 if I enter a "1"

Is there a calculation, operator, or number setting that will make this work.

Thanks ahead of time.

Joe T.

[Joe Troxtel]

This seams like it should be simple but for the life of me I can/t figure it out.

Problem- Short version... I am entering a "1" and I want to return 001. The filed is a number field with a general number format assigned to it.

In Excel you can specify custom number functions by using the ### which will return 001 if I enter a "1"

Is there a calculation, operator, or number setting that will make this work.

Thanks ahead of time.

Joe T.

[comment]

See here .

[comment]

See here .

[Joe Troxtel]

Thanks for the quick point!

I used the, Right ( "000" & Catalog page number ; 3 ), Calc. and I am off and running.

Thanks Again.

Joe T.

[Joe Troxtel]

Thanks for the quick point!

I used the, Right ( "000" & Catalog page number ; 3 ), Calc. and I am off and running.

Thanks Again.

Joe T.