Thread: Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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