LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kbrookfi
 
Posts: n/a
Default I want to put a bank account number that begins with 00 in Excel.

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
formatting number value to text value in excel jazzydwit Excel Worksheet Functions 2 December 29th 05 03:17 AM
Excel random number JJ Excel Discussion (Misc queries) 2 May 4th 05 01:19 PM
Excel 2003 random number generator JJ Excel Discussion (Misc queries) 1 May 4th 05 01:02 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"