formating field in text object

[Zbob]

I have an PO number formatted X,XXX.XX (4 digits)

I am trying to put a text object together PO-XXXX-Line number

"PO-"&{PONUM}&"-"&{line num}=
PO-3,526.00-line number

Any help would be appreciated

Thanks

 

[dgillz]

Try this:

totext({PNUM},0,"&quot

0 being the number of decimal places to display and "" being the thousands separator. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Zbob]

Thanks

that worked.

Any ideas how to change the format of a date in the same situation.

"Prior to-"&{date} = Prior to- 01/01/2001
want Prior to - 01/01/01

 

[dgillz]

Try this:
Left(totext({Date}),6)&right(totext({date}),2) Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com