Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Excel Cell Format

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Excel Cell Format

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Excel Cell Format

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Excel Cell Format

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Excel Cell Format

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Excel Cell Format

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Excel Cell Format



"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
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
In Excel, conditional format (font red) referencing another cell? Christine Hemphill Excel Worksheet Functions 39 November 12th 09 03:40 PM
How do I format a cell in excel to display 0.5 hrs as 00:30 Maxiam Excel Discussion (Misc queries) 2 August 15th 06 10:40 PM
Excel - cell format switches to custom when switching language louisp Excel Discussion (Misc queries) 0 February 10th 06 06:23 PM
How do i get excel to format a cell for a negative result. Cisco Excel Discussion (Misc queries) 4 July 21st 05 08:40 AM
How do I unhide the cell format function in Excel 2000 Len Melcer Excel Worksheet Functions 2 December 15th 04 06:49 PM


All times are GMT +1. The time now is 01:19 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"