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
|