Number Format

[bushrob]

I am trying to duplicate a VB method that takes an integer and converts it to a string as follows:

"A" & Format(intMyInteger, "0000#&quot
This will generate A00001 if the integer passed was 1.

I need to create a Crystal formula that will produce the same results.

Thanks in advance.

 

[synapsevampire]

Create a formula with:

"A"+replicatestring("0", 5- len(totext(PageNumber,0)))+totext(PageNumber,0)

Replace the Pagenumber with your string.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com