Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an Excel working document where I store all of my vital data, such as
logon name, passwords, credit card and bank account numbers, etc, etc. Unfortunaly I have ran into a problem that I cannot solve. My personal Visa credit card number (last digit) ends in the numeric number 9. Everytime I enter the full credit card number into my Excel Date storage document it changes the number to "ZERO" when I navigate away from the cell. I have tried every format that I can think of but cannnot solve this problem. Help PLEASE!!!!! -- Larry D |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Get yourself a proper solution. http://keepass.sourceforge.net/
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... I have an Excel working document where I store all of my vital data, such as logon name, passwords, credit card and bank account numbers, etc, etc. Unfortunaly I have ran into a problem that I cannot solve. My personal Visa credit card number (last digit) ends in the numeric number 9. Everytime I enter the full credit card number into my Excel Date storage document it changes the number to "ZERO" when I navigate away from the cell. I have tried every format that I can think of but cannnot solve this problem. Help PLEASE!!!!! -- Larry D |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for the suggestion, but I currently use RoboForm and like it very well.
However this Excel document is something I have built for years and years and even though most of the data in now in RoboForm, I still keep it up to date. I might add this problem did not occur unitl I started using Office Pro 2007 (Beta). -- Larry D "Bob Phillips" wrote: Get yourself a proper solution. http://keepass.sourceforge.net/ -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... I have an Excel working document where I store all of my vital data, such as logon name, passwords, credit card and bank account numbers, etc, etc. Unfortunaly I have ran into a problem that I cannot solve. My personal Visa credit card number (last digit) ends in the numeric number 9. Everytime I enter the full credit card number into my Excel Date storage document it changes the number to "ZERO" when I navigate away from the cell. I have tried every format that I can think of but cannnot solve this problem. Help PLEASE!!!!! -- Larry D |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
But seriously, Excel is not secure, and if you have stuff like credit card
and bank account details you should use something else. KeePass encrypts it all. Is Roboform similar to KeePass? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... Thanks for the suggestion, but I currently use RoboForm and like it very well. However this Excel document is something I have built for years and years and even though most of the data in now in RoboForm, I still keep it up to date. I might add this problem did not occur unitl I started using Office Pro 2007 (Beta). -- Larry D "Bob Phillips" wrote: Get yourself a proper solution. http://keepass.sourceforge.net/ -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... I have an Excel working document where I store all of my vital data, such as logon name, passwords, credit card and bank account numbers, etc, etc. Unfortunaly I have ran into a problem that I cannot solve. My personal Visa credit card number (last digit) ends in the numeric number 9. Everytime I enter the full credit card number into my Excel Date storage document it changes the number to "ZERO" when I navigate away from the cell. I have tried every format that I can think of but cannnot solve this problem. Help PLEASE!!!!! -- Larry D |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
BTW, to answer your initial question, format the cc cell as text, or precede
with ' (a single apostrophe). -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... Thanks for the suggestion, but I currently use RoboForm and like it very well. However this Excel document is something I have built for years and years and even though most of the data in now in RoboForm, I still keep it up to date. I might add this problem did not occur unitl I started using Office Pro 2007 (Beta). -- Larry D "Bob Phillips" wrote: Get yourself a proper solution. http://keepass.sourceforge.net/ -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... I have an Excel working document where I store all of my vital data, such as logon name, passwords, credit card and bank account numbers, etc, etc. Unfortunaly I have ran into a problem that I cannot solve. My personal Visa credit card number (last digit) ends in the numeric number 9. Everytime I enter the full credit card number into my Excel Date storage document it changes the number to "ZERO" when I navigate away from the cell. I have tried every format that I can think of but cannnot solve this problem. Help PLEASE!!!!! -- Larry D |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Bob ---- Thanks for both of your responses. I'm not familiar with KeePass,
but will investigate it and see what the differences are between it and RoboForm. I have used and do use the ' apostrophe solution, but was hoping their was another way to format the cell so I could store longer numbers. I hate to say this, but I do know that Excel is not necessiarly secure, but I have done everything humanly possible to protect the file and my computer. I'm what you would call a "SECURITY FREAK". Having said that I do realize that the best of the those folks our their who want to hurt you and get data from you have many deviious ways to do so!!!!!! -- Larry D "Bob Phillips" wrote: BTW, to answer your initial question, format the cc cell as text, or precede with ' (a single apostrophe). -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... Thanks for the suggestion, but I currently use RoboForm and like it very well. However this Excel document is something I have built for years and years and even though most of the data in now in RoboForm, I still keep it up to date. I might add this problem did not occur unitl I started using Office Pro 2007 (Beta). -- Larry D "Bob Phillips" wrote: Get yourself a proper solution. http://keepass.sourceforge.net/ -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lfessler" wrote in message ... I have an Excel working document where I store all of my vital data, such as logon name, passwords, credit card and bank account numbers, etc, etc. Unfortunaly I have ran into a problem that I cannot solve. My personal Visa credit card number (last digit) ends in the numeric number 9. Everytime I enter the full credit card number into my Excel Date storage document it changes the number to "ZERO" when I navigate away from the cell. I have tried every format that I can think of but cannnot solve this problem. Help PLEASE!!!!! -- Larry D |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() "lfessler" wrote in message ... Bob ---- Thanks for both of your responses. I'm not familiar with KeePass, but will investigate it and see what the differences are between it and RoboForm. I took a look at RoboForm, and the biggest difference is that KeePass is free. It seems that RoboForm has some extra functions for using tyhat data also. I have used and do use the ' apostrophe solution, but was hoping their was another way to format the cell so I could store longer numbers. I don't think, just seems a limitation of Excel's arithmetic engine. I hate to say this, but I do know that Excel is not necessiarly secure, but I have done everything humanly possible to protect the file and my computer. I'm what you would call a "SECURITY FREAK". Having said that I do realize that the best of the those folks our their who want to hurt you and get data from you have many deviious ways to do so!!!!!! Unfortunately with Excel you don't have to be the best or even devious, it is EASY. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, conditional format (font red) referencing another cell? | Excel Worksheet Functions | |||
How do I format a cell in excel to display 0.5 hrs as 00:30 | Excel Discussion (Misc queries) | |||
Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
How do i get excel to format a cell for a negative result. | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |