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

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

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

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

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

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

David,

Not failsafe AFAIK, but if it blank or "0" you might use:

{ If { =(B26)} = "0"""{ =(B26*.25)} }