Replacing value

[octopuz]

Hi, I need some help, I have a field in a database called "Project Number" this field has a format PXXXX-Y in a drop down list, so user cannot modify the field. I am required to replace this value so that if the user want to print an invoice, the project number is automatically changed from PXXXX-Y to PXXXX00Y in the invoice layout. How does the script look like if I want to implement this? Thank you for your help

[comment]

Use a calculation field =

Left ( Project Number ; 5 ) & "00" & Right ( Project Number ; 1 )

or =

Substitute ( Project Number ; "-" ; "00" )