View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Rachel Rachel is offline
external usenet poster
 
Posts: 113
Default How to enter zip starting with 0 (zero)

I have tried all these suggestions, and nothing is working.

I have a database in Excel and am trying to convert it to Word via mail
merge. (Wouldn't you know, in MA, most zips start with zero??)

Have tried formatting that column as Zip. As text. As text with an
apostrophe. As Custom- 00000.

I'm beginning to feel like I should throw the computer out the window.

Any help would be greatly appreciated!

"Sheeloo" wrote:

Yeah, you are right. Just pointed this out for future use...

"Peo Sjoblom" wrote:

The OP wants to use it for mailmerge in Word then it doesn't matter how they
are numerically formatted


--