Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
OldFatDog OldFatDog is offline
external usenet poster
 
Posts: 4
Default One cell value * an decimaled interger

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!
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default One cell value * an decimaled interger

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!


  #3   Report Post  
Posted to microsoft.public.word.tables
OldFatDog OldFatDog is offline
external usenet poster
 
Posts: 4
Default One cell value * an decimaled interger

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.

"macropod" wrote:

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!



  #4   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default One cell value * an decimaled interger

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]


"OldFatDog" wrote in message ...
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.

"macropod" wrote:

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!




  #5   Report Post  
Posted to microsoft.public.word.tables
cebiii cebiii is offline
external usenet poster
 
Posts: 1
Default One cell value * an decimaled interger

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.

"macropod" wrote:

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]


"OldFatDog" wrote in message ...
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.

"macropod" wrote:

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!






  #6   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default One cell value * an decimaled interger

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]


"cebiii" wrote in message ...
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.

"macropod" wrote:

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]


"OldFatDog" wrote in message ...
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.

"macropod" wrote:

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!





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-populate a MS Word table cell with text from a diff cell? dreamrthts Tables 0 March 20th 09 09:56 PM
Can I have 1 line of text per cell & carriage return to next cell simpkins Tables 2 April 12th 08 03:50 PM
How do I move from cell to cell iin a table column in Word 2003? MOSwannabe Tables 4 January 26th 06 11:17 PM
cell marker missing - can not type text into cell Mary Smith 360 Tables 1 December 20th 05 06:04 AM
How do I auto copy data from cell in a word table to another cell. Nev New Users 1 February 4th 05 09:51 PM


All times are GMT +1. The time now is 03:09 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"