Results 1 to 4 of 4

Thread: How can I block the program from dropping the initial zeros in Excel

  1. #1
    Gentian pedro is offline Senior Member
    Join Date
    Jun 2011
    Posts
    302
    Rep Power
    2

    Default How can I block the program from dropping the initial zeros in Excel

    I do a lot of spread piece with variety that start with one or more zeros. Not concern how many periods I change the cel structure to "text" so that the zeros are not lowered, I figure out that as I go down the piece, they re lowered and I haveto re-format the cels to "text" and alternative the zeros.How can I prevent the plan from losing the preliminary zeros?

  2. #2
    Harold Obert is offline Senior Member
    Join Date
    Jun 2011
    Posts
    295
    Rep Power
    2

    Default

    You can make a custom format (Format, Cells, Custom) and enter the number of zeros that you requirement to view digits for.instance, if you require to view a total of 4 digits, still if you only enter 2 or 3, enter a custom format like "0000". Excel will display "0012" when you enter 12. Be aware that Exceed only shops the 12, but shows it as 0012. Structure the cellular as Textual content .Enter an apostorphe first, then the variety - like '0012 Exceed will not present the apostrophe, just the 0012. Be aware that Exceed will cure this as text, not a variety - won't determine anyone when it's formated as text.

  3. #3
    Harold Daire is offline Senior Member
    Join Date
    Jun 2011
    Posts
    294
    Rep Power
    2

    Default

    This is precisely the trouble I have in testing out to save ISBN numbers which much start with a zero. I have testing out entire three methods you have suggested. Once the text in the column looks right, I preserve it in the xls format, and can start it in excel right. But then I preserve it into the tab delimited.txt file. When I begin the textual content papers in wordpad, I can perspective the statistics are awesome, with the best zero right in place. Then I begin the computer file once again in exceed, and the zeros have been lowered. This is a problems, since I must publish my guides in a tab delineated computer file to Amazon, but the zeros go away, so they don't fill my guides.

  4. #4
    Paschal Baldwin is offline Senior Member
    Join Date
    May 2011
    Posts
    313
    Rep Power
    3

    Default

    I am glad that somebody else has also tested out the 3 solutions that were hint minus success. In my case, the few of the numbers begin with zeros and few do not, depending on the OEM- which eliminates the "special formatting" choice. Unluckily, the several OEM's are not obscure, but combined in the similar columns. Also, if the number is alpha-numeric, Excel sometimes alters the format to scientific- still after the sheet has been proofed and preserved.

Similar Threads

  1. Replies: 3
    Last Post: 06-14-2011, 11:12 AM
  2. Leading zeros
    By MoralesWard in forum Programming
    Replies: 1
    Last Post: 02-06-2010, 02:47 PM
  3. How to create a button to launch my program from Excel
    By Anakin Dilshan in forum Programming
    Replies: 2
    Last Post: 10-22-2009, 12:30 PM
  4. NewEgg dropping low rating for 965?
    By Osana Pancha in forum CPU & Components
    Replies: 5
    Last Post: 08-17-2009, 08:34 AM
  5. Adding Leading zeros in excel 2007
    By Bratton Clovelly in forum Programming
    Replies: 0
    Last Post: 07-25-2009, 09:46 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48