Thread: cell formatting
View Single Post
  #7   Report Post  
Darryl
 
Posts: n/a
Default

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