Hello,
I am generating a salary increase memo in Word for multipe persons. I inserted a mail merge using info from Excel. The problem I am having are the figures when they appear in the memo. For example, if a person's salary is $100,000.00, it coming up as $99999.9929 etc. - I need it to appear as $100,000.00.
What do I need to do in Excel to stop this from happening?
I thank you in advance for your help and responses.
Here's an example of how it's turning out:
Your increase will be effective with pay period ending 7/5/2014 (pay date of7/10/2014). Your new biweekly rate of pay will be 3846.1500000000001(99999.996299999999 annual equivalent).
I need it to be just $3846.15 and $100,000.00.
Bookmarks