Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jess
 
Posts: n/a
Default How do I stop 0's taking up lines in letter when no data in s/shee

I have a list of data which contains names and numbers in an excel
spreadsheet. This is merged into a word document. The number of names
varies (up to 12). In my letter, it will display a 0 in some lines when
there is no name and number in the excel spreadsheet. This looks untidy and
takes up lines - how can I make it stop doing it?

I have formatted all columns in the spreadsheet to text. It is not always
the same column of numbers that is producing a 0 if there is no data, and it
is normally only 2 or 3 out of the 12 lines.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop having new typing delete the next letter? gordy1292 Microsoft Word Help 2 September 13th 05 10:43 PM
stop printing cell lines in excel docs linked to word kbwizard Microsoft Word Help 1 July 21st 05 11:55 PM
Convert to Symbols Omar Menjivar Microsoft Word Help 7 June 27th 05 07:32 PM
How do I stop losing some address lines printing envelopes Billy Bean Microsoft Word Help 1 June 3rd 05 09:28 PM
Date on letter changes to current date when opened - how to stop. BigSkyG Microsoft Word Help 3 January 13th 05 03:13 PM


All times are GMT +1. The time now is 01:45 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"