Excel cell format not displaying properly in mail merge

[Giga_Me]

Hi all - 1st post here and after searching I'm still not sure how to resolve this issue I'm having with a mail merge with Word & Excel (both 2007).

I have a spreadsheet with 1700+ rows and 36 columns. One column of data (no active formulas in any cells) that includes percentages (displayed as 1.75, etc) and text that displays a range of percentages as 1% -3%.

My mail merge is working and displays the individual percentages fine but displays the ranges like 1% -3% as 0.

I've tried different switches in Word and different cell formats in Excel and the issue is still unresolved. I also tried to switch to DDE format but got an error and am using OLE when selecting the data source.

Thanks in advance for any insight/resolution.

Giga_Me

 

[Dan Waterloo]

Hi Giga_Me,

Welcome to the Board.

You have both numbers and text in that first column. Perhaps you could convert the numbers to text so that it is all text and format it the same way as some other column in your spreadsheet that is all text.

 

[Giga_Me]

Hi Giga_Me,

Welcome to the Board.

You have both numbers and text in that first column. Perhaps you could convert the numbers to text so that it is all text and format it the same way as some other column in your spreadsheet that is all text.

Hi Dan - I reformatted to text and this time it worked...not sure why I couldn't get it to do that earlier Thanks for the response!

Giga_Me

 

[Dan Waterloo]

You're welcome, Giga_Me. It was just a guess but I'm glad it worked out for you.