Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|