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