Microsoft Excel won't let me keep a leading 0 in a cell.


  1. Posts : 96
    W7P64
       #1

    Microsoft Excel won't let me keep a leading 0 in a cell.


    I keep the info of twenty some bank accounts on a spreadsheet with columns for interest rate, bank name, routing number, account number, username, password, balance, etc. I added a new row for a new bank which has a routing number of 011303097, but after I enter that into the cell, it drops the leading 0. I have other entries with routing numbers that start with 0 and they are all there. Why won't it stay in this cell?
      My Computer


  2. Posts : 1,784
    Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
       #2

    You need to set the format on all of these cells to Text. This will allow a leading zero.

    If after setting the format to Text, some cells still have the issue, retype the data in those cells. The problem is, if there is already data in the cell, and that data is in a number format, it will retain its format. Only newly-typed data gets the new format.
      My Computer


  3. Posts : 96
    W7P64
    Thread Starter
       #3

    Ahh text, thank you. Don't know how I missed that.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 21:12.
Find Us