Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

18 Jun 2018   #1
atikovi

W7P64
 
 
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 System SpecsSystem Spec
.
18 Jun 2018   #2
mrjimphelps

Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
 
 

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 System SpecsSystem Spec
18 Jun 2018   #3
atikovi

W7P64
 
 

Ahh text, thank you. Don't know how I missed that.
My System SpecsSystem Spec
.

Reply

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




Thread Tools




Similar help and support threads
Thread Forum
Excel cell formats changed after Windows Update
Hi. After getting my wife's laptop with Win 7 Pro to run it's updates again after a week's worth of struggling with that, she opened an existing LARGE spreadsheet to find that all the green cell contents were now blue, and the cells with $ formatting were now general format again !! Not a happy...
Microsoft Office
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
Excel cell
Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are. How can I make this cell...
Microsoft Office
Excel 2010 Multiply cell
I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this? Thanks
Microsoft Office
Excel: How can I insert the value of cell into ActiveX button caption?
Hi, I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 05:25.
Twitter Facebook Google+