Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Switches that allow 2 different formats
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? |
#2
|
|||
|
|||
Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Switches - Please explain | Mailmerge | |||
Clear all formats and styles | Microsoft Word Help | |||
Word Switches | Microsoft Word Help | |||
Separate formats btwn separate sections?? | Page Layout | |||
FINDING AND REPLACING FORMATS | Microsoft Word Help |