Thread: I want to put a bank account number that begins with 00 in Excel.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ForSale
 
Posts: n/a
Default I want to put a bank account number that begins with 00 in Excel.

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.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=520438

Reply With QuoteReply With Quote