Hello. I am hoping to find someone willing to assist me with a project. I will pay for your services.

I have a template that was created in MS Word 2007 that is full of form fields. I still have Word 2007 but use Word 365. There are numerous calculations and formulas in the template. They work properly for the most part, but navigating through the fields is far from smooth. I attached a sample.

With the understanding that some of my requests might not even be possible, here are a few things on my wish-list.



First, I would like to tab from field to field vertically instead of the default horizontally. I know there are pages that give some instruction on this, but frankly, it's over my head. Second, in my sample, you will see some "positive" numbers and for those, I need the + sign in front of them similar to how the - shows up for a negative number.
So if I type 3500, I need it to show as +3,500. Right now, I have to unprotect my document, and manually add the + symbol. Lastly, I have a "net" figure at the bottom of my grid that is a percentage. It seems to be rounding to the nearest whole percent. For instance, in my example for comp #1, I need the net to show as -1.25% instead of rounding that to -1.00% which is what it does now.

Maybe these are not possible with the current format. I am open to any suggestions even if I have to reinvent the wheel. There are several other tweaks I would like as well but figured this would be a good starting point. If interested, please let me know. Thank you in advance.

Attached Files

gridsample.docx (30.7 KB, 10 views)

For the + signs, you could insert a field coded along the lines of:
{IF{C1SP}> 0 "+"}
into each cell where you want the + sign to appear. The 'C1SP' needs to be the internal field bookmark for the fields concerned.

To get the tabs to go vertically, you could split the table into four vertical sections and format the page with a 4-column layout. Getting everything lined up and sized correctly is a chore, though. See attached. I've done the first field addition for you.

Attached Files

gridsample.docx (33.0 KB, 9 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]