Hi OldFatDog,
In B10:
.. press Ctrl-F9 to create a pair of field braces (ie '{}')
.. type '=B9*2.20462' (for precision) between the field braces (ie '{=B9*2.20462}')
.. press F9 to update the field.
You can also control how the results of the calculation are displayed, by adding a numeric picture switch to the field. To do this:
.. edit the field so that you get {=B9*2.20462 \# ,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it.
If you've already pressed F9 to update the field, you'll need to precede the above with:
.. select the field (not the whole cell);
.. press Shift-F9 to reveal the field coding.
Other formatting possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
You can also format +ve, -ve and 0 values differently (eg \# ",0.00;(,0.00);--"). If you use a final ';' in the formatting switch
with nothing following, (eg \# ",0.00;-,0.00;") zero values will be suppressed.
For more information on calculations in Word, check out my Word Field Maths Tutorial, at:
http://www.wopr.com/index.php?showtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party
--
Cheers
macropod
[MVP - Microsoft Word]
"OldFatDog" wrote in message ...
My example:
in cell B10 I want the result of the value in B9 * 2.204, in other words I
need the formula to convert pounds in one column into kilograms in the column
to the right. I seem very busy at frustrating myself over something that has
to be easier than I am making it!