Thread: cell formatting
View Single Post
  #4   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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