Help
 

Can someone tell me why when a series of numbers, such as 01234 is put into a
cell the 0 does not appear? Is there a way to make it appear? Also, while
doing a mail merge a document printed differently than how it appeared on the
word document, does anyone have an idea on why this happened and how to
prevent it from occuring again?

Thank you,
CJ

Help
 

For your first question, enter the number with an apostrophe in front,
like '01234 (the apostrophe will not show in the cell), or pre-format
the cell(s) as Text before you enter the number Both of these methods
will treat the number as if it were a text string.

If you want the number as a number (to do arithmetic on it), then
apply a custom format to the cell, set to 00000.

Hope this helps.

Pete

On Apr 24, 4:27*pm, CJ wrote:
Can someone tell me why when a series of numbers, such as 01234 is put into a
cell the 0 does not appear? *Is there a way to make it appear? *Also, while
doing a mail merge a document printed differently than how it appeared on the
word document, does anyone have an idea on why this happened and how to
prevent it from occuring again?

Thank you,
CJ

Help
 

to ways,

format as custom 0#0000

or format cell as text and type 01234

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"CJ" escreveu:

Can someone tell me why when a series of numbers, such as 01234 is put into a
cell the 0 does not appear? Is there a way to make it appear? Also, while
doing a mail merge a document printed differently than how it appeared on the
word document, does anyone have an idea on why this happened and how to
prevent it from occuring again?

Thank you,
CJ

Help
 

Hi,
Can't help on the mail-merge thing, but about losing leading zeros:
One way: Format your cells as 'Text' before entering data.
Another way: instead of 0123, enter '0123
The apostrophe won't show in the cell, and the zero will be retained.
Regards - Dave.

Help
 

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.

CJ wrote:

Can someone tell me why when a series of numbers, such as 01234 is put into a
cell the 0 does not appear? Is there a way to make it appear? Also, while
doing a mail merge a document printed differently than how it appeared on the
word document, does anyone have an idea on why this happened and how to
prevent it from occuring again?

Thank you,
CJ

--

Dave Peterson