Hello,
I would like to format a money field type tfgld.amnt

I need to show the character "N" instead minus sign, for negative values, and blank in other case.
I would like to complete wiht "0" until complete a determinated number of postions.
I would like 2 postions decimals...

Example, for -432487.6 , need to obtain: N00043248760

I write this... ZZZZZZZZZZZZZV99 but I dont go on to obtain the desired result.
Thanks,
María

You can use sprintf$ for this purpose for absolute value (abs function ) of the amount and concatenate the same "N" or " "depending whether the value is negative or positive.