Switches that allow 2 different formats

[BCBC]

I'm creating a form that has an expense table. The form might be filled out
in Word or might be filled out by hand. I've added a switch (e.g., {=B13*C13
\#"$0.00;;" } to the formulas so that the outcome will result in a blank cell
if nothing is typed in or a number formatted with a dollar sign and 2
decimals if a number is typed in.

One of my users just informed me that her department will occacionally type
"APPROVED" in the cells in the expense table instead of putting in an actual
number. However, my current formatting changes "APPROVED" to "$0.00". My
question is: Can I set up the cells to show nothing if the cell is left
blank, a number formatted as "$0.00" if a number is typed in, or text if
letters are typed in?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?QkNCQw==?=,

This would require a purely macro solution, as you'd have to revert the form
field type to "text". When the user exits the form field, a macro (OnExit) would
be triggered that would check the content of the field and change it (apply
number formatting) as required.

I'm creating a form that has an expense table. The form might be filled out
in Word or might be filled out by hand. I've added a switch (e.g., {=B13*C13
\#"$0.00;;" } to the formulas so that the outcome will result in a blank cell
if nothing is typed in or a number formatted with a dollar sign and 2
decimals if a number is typed in.

One of my users just informed me that her department will occacionally type
"APPROVED" in the cells in the expense table instead of putting in an actual
number. However, my current formatting changes "APPROVED" to "$0.00". My
question is: Can I set up the cells to show nothing if the cell is left
blank, a number formatted as "$0.00" if a number is typed in, or text if
letters are typed in?

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