Format when "0" is the first letter

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: cpliu (chanciusliuDeleteThis_at_yahoo.com)
Date: 07/16/04 

Date: 16 Jul 2004 20:45:02 GMT

I have a Excel document that has many cells with "0" as the first character
of a string of numbers. When I change the format to number, the "0" would
disappear. If I use Custom and type multiple 0s, the 0 stays but they would
not stay when I do mail merge in Word.

What can I do to retain the "0" in Excel and be able to mail merge without
losing the "0"?

Thanks,

cpliu

Relevant Pages

  • Re: Concantenate issues ...
    ... need to transfer the new longer number to a different excel document, ... If this is indeed a number, Excel can only handle 15 significant digits, so ... the number is likely to be changed after concatenation. ... apostrophe to the beginning of the string to keep it as a string. ...
    (microsoft.public.mac.office.excel)
  • Re: VLOOKUP and table_array
    ... "NameOfSomething" anywhere in my Excel document. ... If it is just a text string rather than a range such as Sheet1!$A$1:$C$10 ... name drop down towards the left of the formula bar, ... excuse for it in my mind is if you need to access Excel sheets on a computer ...
    (microsoft.public.vb.general.discussion)
  • Re: xslt Transform efficiently
    ... return a single table from a web page into an Excel document. ... Pascal Schmitt. ...
    (microsoft.public.dotnet.xml)
  • Re: Mailmerge question
    ... section and check the box for "Confirm file format conversion at open" ... I have formatted the original Excel document cells to ... cells had no document highlighted under Format cell. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word Mail Merge Date Format
    ... up and saves it out to an excel document - which is used as input to ... another look, but on the business of connecting to text files, recently I started having a more thorough look at this and discovered that by using a ..odc file to specify the data source, you can also get the OLE DB provider to look at the SCHEMA.INI file containing information - including character encoding - about specified text files. ... One bit of information that isn't in that message is that the SCHEMA.INI lets you specify a date format. ...
    (microsoft.public.word.mailmerge.fields)