how to retain leading zeros i.e. 00001 instead of 1
 

I need to set up a spreadsheet for a mail merge, so that it prints 00001,
but of course it defaults to 1. How do I show the 0s?

how to retain leading zeros i.e. 00001 instead of 1
 

Use a custom format of 00000.

Does this help?

--
Regards,
Fred


"Sue" wrote in message
...
I need to set up a spreadsheet for a mail merge, so that it prints 00001,
but of course it defaults to 1. How do I show the 0s?

how to retain leading zeros i.e. 00001 instead of 1
 

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.

Sue wrote:

I need to set up a spreadsheet for a mail merge, so that it prints 00001,
but of course it defaults to 1. How do I show the 0s?

--

Dave Peterson