P
Paul J
I am creating a (Word 2003) protected form using Text Form Fields to accept
input (and to perform a calculation on previously input Number fields).
The Number Format dropdown box in the Text Form Field Options menu where the
Type is Number, offers only a limited set of number of available formats.
One of these formats, £#,##0.00;(£#,##0.00), can be edited to
£#,##0;(£#,##0) to allow input of values of whole Pounds (Sterling) only.
HOWEVER, I am not happy with the format of the negative values (i.e. in
parentheses) and I would REALLY prefer to use "£,0;-£,0".
I am able to use my prefered number format to display the result in the
Calculation type of Text Form Field - but I have been unable to see how I can
apply this format to a(n input) Number type Text Form Field.
Can anybody help, please?
PJ
input (and to perform a calculation on previously input Number fields).
The Number Format dropdown box in the Text Form Field Options menu where the
Type is Number, offers only a limited set of number of available formats.
One of these formats, £#,##0.00;(£#,##0.00), can be edited to
£#,##0;(£#,##0) to allow input of values of whole Pounds (Sterling) only.
HOWEVER, I am not happy with the format of the negative values (i.e. in
parentheses) and I would REALLY prefer to use "£,0;-£,0".
I am able to use my prefered number format to display the result in the
Calculation type of Text Form Field - but I have been unable to see how I can
apply this format to a(n input) Number type Text Form Field.
Can anybody help, please?
PJ