Sorry, Darryl. Hope I didn't sound condescending--didn't mean to.
The easiest way to accomplish this would be to put the % outside the form
field and just format the cell as 0.00. Otherwise, methinks you'll need a
macro.
*******************
~Anne Troy
www.OfficeArticles.com
"Darryl" wrote in message
...
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