Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hello,


    I have a sortable (Excel 2003) spreadsheet with multiple columns.

    In one of my columns I am trying to input a series of two digit numbers,
    such as:

    01
    02
    03
    04

    But, when I input a two digit number (e.g. 01) starting with a zero, Excel
    removes the zero. The only way I found to keep the zero is to put an apostrophe ' in the front of the zero.

    I have seen the same thing occur in Access 2003 too and was wondering if there was a default setting in Excel 2003 to keep the number there as I had entered it. Does anyone know if this is possible?

    Thanks in advance for the asistance.

    Regards,

    Jim

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    371
    Thanked 1,457 Times in 1,326 Posts
    Jim,

    You need to set up a custom number format of "00". Then format the cells in question using that format.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hi RG,

    That's fantastic! It works great.


    Thanks for the assistance.

    Regards,

    -J

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •