Thanks Anne.

I understand that 8.7 is not 8.7%. But as the users say, I need it this
way.
I don't know how to make it such that when the user leaves the field in the
table, that the resulting value (870%) is divided by 100 so it shows 8.7%
(the goal).

If someone could explain how I can do the division I would be greatly
appreciative.

-Darryl.
"Anne Troy" wrote in message
news:1c097$42d4327b$97c5108d$4574@allthenewsgroups .com...
Hi, Darryl. The whole confusion about percentage formatting is that 8.7 is
not 8.7%. 8.7 percent formatted as a decimal is really 0.087, so that
needs
to be entered, or you need to divide it by 100 so it works the way you
want
it to. This also confuses Excel users.
*******************
~Anne Troy

www.OfficeArticles.com


"Darryl" wrote in message
...
It's not calculated. The user types in the value. The formatting was
to
get it a percentage.
So, the user types in 8.7 and the formatting changes it to 8.7%.


"Suzanne S. Barnhill" wrote in message
...
No macro needed. The fact that you have already applied a number
format
suggests that you're using a field. If it's an = field or (as sounds
more
likely) a calculated form field, all you have to do is add /100 to the
calculation.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup
so
all may benefit.

"Darryl" wrote in message
...
OK then.
How can I create a macro to divide the cell contents (that I am
exiting)
by
100 ?

thanks,
Darryl
"Suzanne S. Barnhill" wrote in message
...
In addition to adding a number format, you'll have to do some math
to
divide
by 100.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup
so
all may benefit.

"Darryl" wrote in message
...
Yes, of course I already knew that.

Rather, I want to enter 8.7 and have

the cell show 8.7%.

how do I accomplish that ?

"Jean-Guy Marcil" wrote in message
...
Darryl was telling us:
Darryl nous racontait que :

Greetings,
I have a table in my word document. One of the cells is
numeric
in
format. I have set the number format
to 0.00%. The problem is when I enter 8.7 it converts it to
870%.
I want it to be 8.7%.

How do I do this ? Do I have to create a macro that
mathematically
converts it ?

Enter
.087
instead.

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