Reply
 
Thread Tools Display Modes
  #1   Report Post  
peter Smith peter Smith is offline
Junior Member
 
Posts: 1
Red face solution needed to prevent empty merged cells showing on document as a zero

I use word 2003 and I am merging from Excel
I am making a lease, the excel documents allows up to 12 people on the lease if there are only 6 or 8 I have many entries on Word that just show up as lower case zeros. this is also true if the person filling in the excel sheet skips a cell so that perhaps whilst 5 address lines are needed only three are used . If the default value were to be $ or # then I could find and replace - but with a zero so much else goes with it .

Is there a setting in excel or Word that can sort this or do I have to re word each formula if so is thee a setting that ensure that blank cells are shown as blank and not with a number or symbol in them ?
Reply
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
count table non empty cells Crios New Users 3 January 30th 10 10:31 PM
White Lines / Empty Spaces above/below cells next to cells with bo Gowgirl4 Tables 1 October 9th 07 06:38 PM
Why is merged document showing tracked changes? Dave's flumuxed Microsoft Word Help 0 May 17th 07 06:50 PM
data selected but not showing on merged document Sara Stilley Mailmerge 1 September 13th 06 09:26 PM
How to prevent Merged Date Field showing time? jmasood Mailmerge 1 February 21st 05 12:59 PM


All times are GMT +1. The time now is 11:36 AM.

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"