Share via

Table Formula Percentage

Anonymous
2013-04-01T22:23:31+00:00

I create a table in Word 2007.

Cell A1 is the number 200.

Cell B1  is the number 100

Cell C1 i is the formula "=B1/A1", and the Number Format is 0.00%.

But what shows up in C1 is ".50%" and not 50.00% which is 100/200 as a percentage result.

Is there a way to fix this?

Thanks to all.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2013-04-02T00:09:17+00:00

    You need to use =B1/A1*100

    If you press Alt+F9 to toggle on the display of the field codes, you will see

    { = BA/A1 # "0.00% }

    Add *100 after A1 and then use Alt+F9 again to toggle off the display of the field codes.

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-04-02T00:24:38+00:00

    Thanks very much.  I will try it.

    The other question is how to copy the C1 formula to C2 and it connects to B2/A2 and not to B1/A1 as that's what it does automatically...

    Thanks again.

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-04-03T22:40:04+00:00

    thanks... I looked into and it's no clear how to do it....

    any thoughts?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2013-04-02T03:04:15+00:00

    It's not clear how to find the answers....and he first link does not even open up...

    Do you know the answers?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2013-04-02T00:42:56+00:00

    It worked, so just waiting to hear back re the other question.

    And the third question is, how do i update all fields at one time, because if I change one of the numbers it affects another cell but it does not do it till I update....and if i do a lot of changes, I would like to update all fields at one time..

    Thanks very much re the next two questions.

    0 comments