I want to put a bank account number that begins with 00 in Excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Because of warnings about keylogging, I want to use Excel for my bank and
credit card numbers so I can copy and paste the numbers instead of keying
them in. But my bank account # starts with 00 and when I key the number the
first two 0s are automatically removed. I would like to keep them there and
cant see how to format the cell so they stay
 
Try Format > Cells and then go to Custom and put in '00000000' or
however many digits your bank accounts are long.
Not sure if that is the best solution, but it might work for a small
project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

bank transfer error numbers display from workbook to csv 1
Credit Score 5
How can I keep a zero (0) at the front of a set of numbers. 2
Find and replace numbers using a formula 6
How can I link data in three different cells? ck# date amount 2
How can I convert Excel .csv to .qif for download into bank acct? 2
Excel Cell Format 13
Copying into excel from a online bank account 4

Back
Top