Help

[CJ]

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

 

[Pete_UK]

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

 

[Marcelo]

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:

 

[Dave]

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.

 

[Dave Peterson]

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/assistance/HA011164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.