Syntax for Number format in the Text Form Field Options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the syntax for Number format in the Text Form Field Options?

I am familiar with the syntax for custom formats in Excel 2002/2003 (i.e.:
positive format; negative format; zero format; text format).

The number format in the Text Form Field Options does not seem to follow
that same general syntax.
 
Hi =?Utf-8?B?RWQgSGFsbCA2MQ==?=,
What is the syntax for Number format in the Text Form Field Options?

I am familiar with the syntax for custom formats in Excel 2002/2003 (i.e.:
positive format; negative format; zero format; text format).

The number format in the Text Form Field Options does not seem to follow
that same general syntax.
Click to expand...
It does follow a similar syntax, but not all options are allowed in that
field in later versions of Word. Is this a data-entry field, or a calculation
field?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Hi Cindy,
The field to which I refer is a calculation field but I would be interested
in knowing the syntax for regular text and number fields as well.

Thank you,
Ed Hall
Monroe, Louisiana, USA
 
Hi =?Utf-8?B?RWQgSGFsbCA2MQ==?=,
The field to which I refer is a calculation field but I would be interested
in knowing the syntax for regular text and number fields as well.
Click to expand...
For non-calculation fields you'd need to use an "Exit" macro to provide formatting
that's not part of the standard options.

For a calculation field, you leave the "Format" field blank, and add the format at
the end of the formula. Roughly, like this:

= qty1*price \# "0.00,-0.00,''"

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-)
 
Back
Top