A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Table



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2004, 03:50 PM
wahoochuck
external usenet poster
 
Posts: n/a
Default Table

Hello everyone.
I am kinda new to Office and I had a question.Are there any good reasons that I would use a Word table to make calculations instead of just using Excel??

Thanks for the help.
  #2  
Old July 8th, 2004, 04:35 PM
Jean-Guy Marcil
external usenet poster
 
Posts: n/a
Default Table

Bonjour,

Dans son message, wahoochuck écrivait :
In this message, wahoochuck wrote:

|| Hello everyone.
|| I am kinda new to Office and I had a question.Are there any good reasons
that I would use a Word
|| table to make calculations instead of just using Excel??
||

If all you are after is doing calculations, then no.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org



  #3  
Old July 8th, 2004, 05:02 PM
external usenet poster
 
Posts: n/a
Default Table

Excel is better if you're doing complicated calculations,
but Word is easy & quick to use for doing simple totals,
e.g., Sum(Above).

-----Original Message-----
Hello everyone.
I am kinda new to Office and I had a question.Are there

any good reasons that I would use a Word table to make
calculations instead of just using Excel??

Thanks for the help.
.

  #4  
Old July 9th, 2004, 10:22 AM
Derick Chapman
external usenet poster
 
Posts: n/a
Default Table

I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong?
--
Derick in Essex UK


" wrote:

Excel is better if you're doing complicated calculations,
but Word is easy & quick to use for doing simple totals,
e.g., Sum(Above).

-----Original Message-----
Hello everyone.
I am kinda new to Office and I had a question.Are there

any good reasons that I would use a Word table to make
calculations instead of just using Excel??

Thanks for the help.
.


  #5  
Old July 9th, 2004, 10:57 AM
Kathleen
external usenet poster
 
Posts: n/a
Default Table

-----Original Message-----
I have a problem with Sum(Above) in a table - however

hard I try, the 'Sum' just returns the message '!Invalid
Character Setting'. Does anyone know what is going wrong?
--
Derick in Essex UK


(a) Did you insert it by using Table Formula or Insert
Field Formula? (you can't just type in the text)


(b) Is it a complicated table? I think Sum(Above) only
works well if none of the cells are [or were ever]
merged.
(c) Try creating a very simple 1 column, 3 row table with
no formatting. In the first row type 2. In the cell
below, type 2. In the cell below do Table Formula Sum
(Above) and click OK. the value in row 3 should be 4.
  #6  
Old July 9th, 2004, 11:08 AM
Kathleen
external usenet poster
 
Posts: n/a
Default Table ... and answering your real question


-----Original Message-----
I have a problem with Sum(Above) in a table - however

hard I try, the 'Sum' just returns the message '!Invalid
Character Setting'. Does anyone know what is going

wrong?
--
Derick in Essex UK


Sorry just read your original question again. Are you
using ordinary text & fonts (not graphics or symbols) in
the cells you're trying to sum up?

For example, if the font is a symbol font or something
like Wingdings, Webdings or Monotype Sorts, a character
might look like a number but actually be another
character entirely, like a, x or %.
  #7  
Old July 9th, 2004, 11:27 AM
Derick Chapman
external usenet poster
 
Posts: n/a
Default Table ... and answering your real question

Kathleen, thanks for the reply. Unfortunately, I've even tried creating a 'test' table of only a few rows and columns with all set to Times New Roman. Still get the same error message
--
Derick in Essex UK


"Kathleen" wrote:


-----Original Message-----
I have a problem with Sum(Above) in a table - however

hard I try, the 'Sum' just returns the message '!Invalid
Character Setting'. Does anyone know what is going

wrong?
--
Derick in Essex UK


Sorry just read your original question again. Are you
using ordinary text & fonts (not graphics or symbols) in
the cells you're trying to sum up?

For example, if the font is a symbol font or something
like Wingdings, Webdings or Monotype Sorts, a character
might look like a number but actually be another
character entirely, like a, x or %.

  #8  
Old July 12th, 2004, 02:17 AM
garfield-n-odie
external usenet poster
 
Posts: n/a
Default Table

Hi, Derick. The problem could be that in your computer, the decimal symbol and the list separator are both the same character (for example, a comma), in which case Word cannot successfully parse an expression. For example, Word cannot determine whether "100,2" represents 100.2 or 100 and 2. To work around this problem, change the list separator under the regional options to a semicolon. To do this, follow these steps:
1. Click Start, point to Settings, and then click Control Panel.
2. Double-click the Regional Settings icon (Microsoft Windows NT or Microsoft Windows 98) or the Regional Options icon (Microsoft Windows 2000).
3. On the Numbers tab (Windows NT) or the Number tab (Windows 2000 or Windows 98) in the List separator box, type a semicolon ( and then click OK.


"Derick Chapman" wrote:

I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong?
--
Derick in Essex UK


" wrote:

Excel is better if you're doing complicated calculations,
but Word is easy & quick to use for doing simple totals,
e.g., Sum(Above).

-----Original Message-----
Hello everyone.
I am kinda new to Office and I had a question.Are there

any good reasons that I would use a Word table to make
calculations instead of just using Excel??

Thanks for the help.
.


  #9  
Old July 13th, 2004, 09:52 AM
Derick Chapman
external usenet poster
 
Posts: n/a
Default Table

Thanks for the suggestion 'garfield-n-odie'. I've amended as suggested, but still get the same error message! I'm using "." for decimal, "," to break thousands and now ";" as the list separator. Any other ideas?
--
Derick in Essex UK


"garfield-n-odie" wrote:

Hi, Derick. The problem could be that in your computer, the decimal symbol and the list separator are both the same character (for example, a comma), in which case Word cannot successfully parse an expression. For example, Word cannot determine whether "100,2" represents 100.2 or 100 and 2. To work around this problem, change the list separator under the regional options to a semicolon. To do this, follow these steps:
1. Click Start, point to Settings, and then click Control Panel.
2. Double-click the Regional Settings icon (Microsoft Windows NT or Microsoft Windows 98) or the Regional Options icon (Microsoft Windows 2000).
3. On the Numbers tab (Windows NT) or the Number tab (Windows 2000 or Windows 98) in the List separator box, type a semicolon ( and then click OK.


"Derick Chapman" wrote:

I have a problem with Sum(Above) in a table - however hard I try, the 'Sum' just returns the message '!Invalid Character Setting'. Does anyone know what is going wrong?
--
Derick in Essex UK


" wrote:

Excel is better if you're doing complicated calculations,
but Word is easy & quick to use for doing simple totals,
e.g., Sum(Above).

-----Original Message-----
Hello everyone.
I am kinda new to Office and I had a question.Are there
any good reasons that I would use a Word table to make
calculations instead of just using Excel??

Thanks for the help.
.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table Error Message Di New Users 2 June 30th, 2004 07:57 AM
Table Analyser and more... Mary Ann Database Design 2 June 29th, 2004 06:36 PM
resize table from A4 size to A5 ims New Users 3 June 9th, 2004 01:05 AM
COMPARE THE TWO TABLES Stefanie General Discussion 0 June 4th, 2004 04:36 PM
Table design for a booking system Brian C Database Design 2 April 27th, 2004 03:11 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.