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 » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Invalid Character Setting



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2004, 07:18 AM
Me
external usenet poster
 
Posts: n/a
Default Invalid Character Setting


When I enter any field with a formula (example subtracting
a number from NUMPAGES), the result of the formula is

!Invalid Character Setting

This happens one one machine only - the same document
gives correct result when opened from another machine.

Any ideas?
Ads
  #2  
Old April 25th, 2004, 09:00 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

You could try the following - they are both to do with the settings for the
"decimal separator" in regional options, which could explain why only one
machine is going wrong:

http://support.microsoft.com/default...kb;en-us;81059

http://support.microsoft.com/default...b;en-us;284921


--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

"Me" wrote in message
...

When I enter any field with a formula (example subtracting
a number from NUMPAGES), the result of the formula is

!Invalid Character Setting

This happens one one machine only - the same document
gives correct result when opened from another machine.

Any ideas?



  #3  
Old April 25th, 2004, 09:30 AM
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

:-)
already tried that, no luck. Besides, it's happening with
page numbers, which are not decimals. Or will it have the
same effect?



-----Original Message-----
You could try the following - they are both to do with

the settings for the
"decimal separator" in regional options, which could

explain why only one
machine is going wrong:

http://support.microsoft.com/default.aspx?scid=kb;en-

us;81059

http://support.microsoft.com/default.aspx?scid=kb;en-

us;284921


--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

"Me" wrote in

message
...

When I enter any field with a formula (example

subtracting
a number from NUMPAGES), the result of the formula is

!Invalid Character Setting

This happens one one machine only - the same document
gives correct result when opened from another machine.

Any ideas?



.

  #4  
Old April 26th, 2004, 09:07 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

already tried that, no luck.

Worth checking that /all/ the different settings including the "list
separator" were different?

Besides, it's happening with
page numbers, which are not decimals. Or will it have the
same effect?


I can generate the error here even with

{ = 0 }

so the fact that Word does not need to display any of these characters is
apparently not relevant.

I don't have any further ideas on this one at the moment, other than that I
would verify that the problem is occurring with the simplest possible test
document (e.g. with just { = 0 } in it, or some such, and if not, check that
all the characters are what they seem to be & in the fonts you expect, that
there are no hidden characters such as no-width spaces, and that Word is not
"autocorrecting" something while you're not looking.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

wrote in message
...
:-)
already tried that, no luck. Besides, it's happening with
page numbers, which are not decimals. Or will it have the
same effect?



-----Original Message-----
You could try the following - they are both to do with

the settings for the
"decimal separator" in regional options, which could

explain why only one
machine is going wrong:

http://support.microsoft.com/default.aspx?scid=kb;en-

us;81059

http://support.microsoft.com/default.aspx?scid=kb;en-

us;284921


--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

"Me" wrote in

message
...

When I enter any field with a formula (example

subtracting
a number from NUMPAGES), the result of the formula is

!Invalid Character Setting

This happens one one machine only - the same document
gives correct result when opened from another machine.

Any ideas?



.



  #5  
Old April 26th, 2004, 10:42 AM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

Hi Peter (and "anonymous")

I can generate the error here even with

{ = 0 }

Then I'd say this could be due to the nasty problems with
NumPages not updating as it ought.

Although I should add that when I put exactly this formula
into Word 2003 I don't see the error, I see "0"

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

  #6  
Old April 26th, 2004, 01:54 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

Hi both,

Starting with the US regional options, if I change the list separator to "."
then try { = 0 } I get the error in Word 2003.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

"Cindy M -WordMVP-" wrote in message
news:[email protected]
Hi Peter (and "anonymous")

I can generate the error here even with

{ = 0 }

Then I'd say this could be due to the nasty problems with
NumPages not updating as it ought.

Although I should add that when I put exactly this formula
into Word 2003 I don't see the error, I see "0"

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)



  #7  
Old April 26th, 2004, 04:14 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

Hi Peter,

Starting with the US regional options, if I change the list separator to "."
then try { = 0 } I get the error in Word 2003.

Got it. Don't know why anyone would use a period as a list separator, but...
I'd say Word can't resolve the conflict between decimal and list separator
being the same?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

  #8  
Old April 26th, 2004, 06:26 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Invalid Character Setting

Got it. Don't know why anyone would use a period as a list separator,
but...

Got it. Don't know why anyone would use a period as a list separator,

but...
I'd say Word can't resolve the conflict between decimal and list separator
being the same?


I don't know either, but I would guess that the problem described in the KB
articles has more to do with
a. conflict between the various different separators as defined in regional
settings
b. and/or conflict between those separators and the ones assumed by Word -
in which case the standard settings for some non-US regions may cause the
problem. There is (or was - haven't checked specifically in Word 2003)
definitely some hard-coding in Word concerning regional options somewhere in
this area, as Word is definitely not completely locale-neutral when it comes
to applying numeric formatting defined in \# switches.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

"Cindy M -WordMVP-" wrote in message
news:[email protected]
Hi Peter,

Starting with the US regional options, if I change the list separator to

"."
then try { = 0 } I get the error in Word 2003.

Got it. Don't know why anyone would use a period as a list separator,

but...
I'd say Word can't resolve the conflict between decimal and list separator
being the same?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)



 




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


All times are GMT +1. The time now is 05:32 PM.


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