One cell value * an decimaled interger

[OldFatDog]

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!

 

[macropod]

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

 

[OldFatDog]

Hello macropod!

This is what I typed into the field {=B9*2.20462\#,0.00} then I
put the curcer in the field Ijust typed, pressed F9, the formula goes away
and I am left with 0.00 , so where did I go wrong?

BTW, B9 has 10,260 in it.

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]

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!

 

[macropod]

Hi OldFatDog,

With the field coded correctly, you should get '22,619.40'.

Are your *sure* the 10,260 is in B9? Try selecting the cell with the value in it then running the macro in the file from the link I
gave you to get the cell's address displayed on the Word status bar.

--
Cheers
macropod
[MVP - Microsoft Word]

Hello macropod!

This is what I typed into the field {=B9*2.20462\#,0.00} then I
put the curcer in the field Ijust typed, pressed F9, the formula goes away
and I am left with 0.00 , so where did I go wrong?

BTW, B9 has 10,260 in it.

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]

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!

 

[cebiii]

This problem is right in line with what I'm doing. I've been able to enter
the formula but am trying to find an auto update function when of the cells
change value. I can make it work upon print but not without a manual F9 for
each field.

Hi OldFatDog,

With the field coded correctly, you should get '22,619.40'.

Are your *sure* the 10,260 is in B9? Try selecting the cell with the value in it then running the macro in the file from the link I
gave you to get the cell's address displayed on the Word status bar.

--
Cheers
macropod
[MVP - Microsoft Word]

Hello macropod!

This is what I typed into the field {=B9*2.20462\#,0.00} then I
put the curcer in the field Ijust typed, pressed F9, the formula goes away
and I am left with 0.00 , so where did I go wrong?

BTW, B9 has 10,260 in it.

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]


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!

 

[macropod]

Hi cebiii,

Unless you're using formfields in a document protected for forms, there is no 'auto-recalc' function like Excel has. Fields can by
updated via F9, print preview and printing the document (provided the 'update fields' option is checked in Tools|Options|Print).

--
Cheers
macropod
[MVP - Microsoft Word]

This problem is right in line with what I'm doing. I've been able to enter
the formula but am trying to find an auto update function when of the cells
change value. I can make it work upon print but not without a manual F9 for
each field.

Hi OldFatDog,

With the field coded correctly, you should get '22,619.40'.

Are your *sure* the 10,260 is in B9? Try selecting the cell with the value in it then running the macro in the file from the link
I
gave you to get the cell's address displayed on the Word status bar.

--
Cheers
macropod
[MVP - Microsoft Word]

Hello macropod!

This is what I typed into the field {=B9*2.20462\#,0.00} then I
put the curcer in the field Ijust typed, pressed F9, the formula goes away
and I am left with 0.00 , so where did I go wrong?

BTW, B9 has 10,260 in it.

:

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]


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!