Text Form Field Options for %

[David Cahill]

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]

0.000%

 

[Stefan Blom]

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


in message
news:[email protected]...

 

[David Cahill]

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%

 

[David Cahill]

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

 

[Suzanne S. Barnhill]

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.

 

[Greg Maxey]

David,

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

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