Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
formatting number value to text value in excel | Excel Worksheet Functions | |||
Excel random number | Excel Discussion (Misc queries) | |||
Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |