Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
Word 2000
Part I: What is the correct Number Format to use for % if I want to have 3 places behind the decimal? I want to be able to enter 7.5, 7.50 or 7.500 in a cell and have all 3 entries come back with 7.500%. I am using #.###% but it does not add the extra zeroes: 7.5 comes back as 7.5% (I have identified this cell as B26 for Part II) Part II: I want the cell next to it to autopopulate as B26 + .25 (7.750% in the example above) When I put =B26+.25 in the expression field, it does not work. It comes back as 0.32, not 7.75% Part III: How would I code it so that the cells with the calculations would remain blank until the user entered the base data into B26? Thank you |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
0.000%
"David Cahill" wrote in message ... Word 2000 Part I: What is the correct Number Format to use for % if I want to have 3 places behind the decimal? I want to be able to enter 7.5, 7.50 or 7.500 in a cell and have all 3 entries come back with 7.500%. I am using #.###% but it does not add the extra zeroes: 7.5 comes back as 7.5% (I have identified this cell as B26 for Part II) Part II: I want the cell next to it to autopopulate as B26 + .25 (7.750% in the example above) When I put =B26+.25 in the expression field, it does not work. It comes back as 0.32, not 7.75% Part III: How would I code it so that the cells with the calculations would remain blank until the user entered the base data into B26? Thank you |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
1. To make zeroes display, use #.000 (if you want zeroes before the
decimal point to display, use 0.000 instead) in the format code. 2. Are you referring to creating relative cell references as in a spreadsheet? This is not possible in Word; all references are absolute. -- Stefan Blom Microsoft Word MVP "David Cahill" wrote in message ... Word 2000 Part I: What is the correct Number Format to use for % if I want to have 3 places behind the decimal? I want to be able to enter 7.5, 7.50 or 7.500 in a cell and have all 3 entries come back with 7.500%. I am using #.###% but it does not add the extra zeroes: 7.5 comes back as 7.5% (I have identified this cell as B26 for Part II) Part II: I want the cell next to it to autopopulate as B26 + .25 (7.750% in the example above) When I put =B26+.25 in the expression field, it does not work. It comes back as 0.32, not 7.75% Part III: How would I code it so that the cells with the calculations would remain blank until the user entered the base data into B26? Thank you |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
Jezebel, thank you for your response. For some reason, 0.000% comes back
with 750.000% when I input 7.5 ##.###% gets the decimal in the correct place (I need to be able to enter interest rates that have double digits) but it does not populate the zeroes. 7.5 comes back with 7.5% instead of 7.500% "Jezebel" wrote: 0.000% "David Cahill" wrote in message ... Word 2000 Part I: What is the correct Number Format to use for % if I want to have 3 places behind the decimal? I want to be able to enter 7.5, 7.50 or 7.500 in a cell and have all 3 entries come back with 7.500%. I am using #.###% but it does not add the extra zeroes: 7.5 comes back as 7.5% (I have identified this cell as B26 for Part II) Part II: I want the cell next to it to autopopulate as B26 + .25 (7.750% in the example above) When I put =B26+.25 in the expression field, it does not work. It comes back as 0.32, not 7.75% Part III: How would I code it so that the cells with the calculations would remain blank until the user entered the base data into B26? Thank you |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
Stefan,
Thank you for taking the time to help me with my question. I appreciate your help. I have installed Greg Maxey's Macro giving me the absolute referecnces for the cells in my tables. b26 is the absolute position for my cell. I have also figured out the expression for the calculation. =b26+.25% 0.000% is the number field This gets me the calculations that I am after. Is there a way to put a switch into the formula so that the cell remains "blank" unless data is entered into b26? thanks "Stefan Blom" wrote: 1. To make zeroes display, use #.000 (if you want zeroes before the decimal point to display, use 0.000 instead) in the format code. 2. Are you referring to creating relative cell references as in a spreadsheet? This is not possible in Word; all references are absolute. -- Stefan Blom Microsoft Word MVP "David Cahill" wrote in message ... Word 2000 Part I: What is the correct Number Format to use for % if I want to have 3 places behind the decimal? I want to be able to enter 7.5, 7.50 or 7.500 in a cell and have all 3 entries come back with 7.500%. I am using #.###% but it does not add the extra zeroes: 7.5 comes back as 7.5% (I have identified this cell as B26 for Part II) Part II: I want the cell next to it to autopopulate as B26 + .25 (7.750% in the example above) When I put =B26+.25 in the expression field, it does not work. It comes back as 0.32, not 7.75% Part III: How would I code it so that the cells with the calculations would remain blank until the user entered the base data into B26? Thank you |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
7.5 *is* 750%. If you want 7.5%, you'll need 0.075. Or you'll need a
calculated field that divides by 100; that's the way percents work. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "David Cahill" wrote in message ... Jezebel, thank you for your response. For some reason, 0.000% comes back with 750.000% when I input 7.5 ##.###% gets the decimal in the correct place (I need to be able to enter interest rates that have double digits) but it does not populate the zeroes. 7.5 comes back with 7.5% instead of 7.500% "Jezebel" wrote: 0.000% "David Cahill" wrote in message ... Word 2000 Part I: What is the correct Number Format to use for % if I want to have 3 places behind the decimal? I want to be able to enter 7.5, 7.50 or 7.500 in a cell and have all 3 entries come back with 7.500%. I am using #.###% but it does not add the extra zeroes: 7.5 comes back as 7.5% (I have identified this cell as B26 for Part II) Part II: I want the cell next to it to autopopulate as B26 + .25 (7.750% in the example above) When I put =B26+.25 in the expression field, it does not work. It comes back as 0.32, not 7.75% Part III: How would I code it so that the cells with the calculations would remain blank until the user entered the base data into B26? Thank you |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Text Form Field Options for %
David,
Not failsafe AFAIK, but if it blank or "0" you might use: { If { =(B26)} = "0"""{ =(B26*.25)} } |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make a form field autopupulate with text from another field | Tables | |||
Autofill of Text Form Field based on another Text Form Field | Microsoft Word Help | |||
Text form field inside WORD table cell, odd selection behavior | Microsoft Word Help | |||
Text Form Field Options | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |