Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
cell formatting
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 ? thanks, -Darryl |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell formatting | Microsoft Word Help | |||
Form Fields lose bold formatting | Microsoft Word Help | |||
word table cell resize or word table cell size change or word table change cell size | Tables | |||
numeric formatting within a cell | Tables | |||
Apply Style but keep direct formatting? | New Users |