Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Mail merge with EXCEL data question?
I'm doing a mail merge with Microsoft Word. The data i'm pulling is in an excel document. The formulated value in a certain cell reads "6.62%". When I merge it into word, I need it to read "6.62%". Instead, it reads the true value of the cell which is 6.6199999999999995E-2. I can not manually type 6.62% into the cell as it is a formulated cell. Please help! Thanks!!
I just tried changing the cell to 6.62% instead of it being a formula, and it STILL is having the same issue. I'm going nuts.
It's already formatted as percentage and 2 decimal places.
That won't work because I need it to read 6.62%. It is a formulated cell that is already formatted as a percentage. Is there anything that can be done in Word perhaps?
2 Answers
- 1 decade agoFavorite Answer
Go to format on the toolbar, click on cells, On the Number tab, in the options window choose percent and then select the number of decimal places.
- 1 decade ago
Try changing the cell format from general or percentage to text and then copy and paste it in word. It might work
