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 ?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.

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

"Cindy M -WordMVP-" wrote:

Hi ?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.

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 ?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.

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,''"

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.

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 :-)