Format a Number in a Calculation?

[Tissot]

Hi Guys,

I've got a small problem:

Got a Global field giving me an Invoice Nr. now I would like to make it look better, instead of just "1" I would like it to be "0001", "0002"..."0010" etc. I've also got a Date conbined in it, like this:

 Right( "0000" & Year ( Get ( CurrentDate ) )  &  Right (  Month ( Get ( CurrentDate ) ); 2 ); 4 )  & RGNr::RGNr & "-1" 

its the "RGNr::RGNr" wich is a global field to be formated. The example shown looks like this now: "04111-1" to be: "04110001-1 Is this possible in a calculation?

Thanks!

[Tissot]

I'm so thick, I've got it!

Sorry, just ignore this Post!

It looks like this now:

 Right( "0000" & Year ( Get ( CurrentDate ) )  &  Right (  Month ( Get ( CurrentDate ) ); 2 ); 4 ) & Right("0000" & RGNr::RGNr; 4) & "-3"