field loses formating on concat

[samonwalkabout]

I have a number field set to 000/\00 this retains the intial char even if zero ie 012/34. I have a problem with this feild being Concatenated into a text box.

ie.

="Project " & [project]

gives me Project 1234

Not Project 012/34

I have tried it in VB and as an expression same thing. How can i make it retain its format?

 

[pdx_man]

Try:
="Project " & Format ([project],"000/00")

 

[samonwalkabout]

Thanks PDX_Man Thats fixed it!