View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do I get rid of the green triangle/upper left cell corner

I bet that those offending zipcodes aren't really text--they don't have the
leading apostrophe.

I bet that they've got a custom format:
format|Cells|Number tab
either Special category (zip code)
or
Custom and something like:
00000

(Saved from a previous post.)

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.



vera wrote:

I have a column of zip codes, some of which begin with '0'. We're using a
mail merge to create letters; we have the apostrophe before the numeric text
so that the '0's will print, but something is happening and halfway through
the merge results the zip codes start losing digits! What can this be?


--

Dave Peterson