#1   Report Post  
kmcguire
 
Posts: n/a
Default Credit Card #

When I place a CC# into my excel worksheet it is changing the last number
(16) to a zero. How can this be stopped
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

format the cell(s) as text first

or

precede your credit card number with an apostrophe:

'1234123412341234

(Excel only keeps track of up to 15 digits in real numbers.)

kmcguire wrote:

When I place a CC# into my excel worksheet it is changing the last number
(16) to a zero. How can this be stopped


--

Dave Peterson
  #3   Report Post  
Paul
 
Posts: n/a
Default

Formatting cells as text in advance is good, but I prefer to precede the
number with a "cc". This makes it clearly visible that the last digit has not
been changed to 0. If I need to, I can revert to a pure number via the
formula =right(A1, (len(A1)-2)).

Regards
Paul

"kmcguire" wrote:

When I place a CC# into my excel worksheet it is changing the last number
(16) to a zero. How can this be stopped

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
How long will it take to pay off my credit card Wayneca Excel Discussion (Misc queries) 3 May 9th 05 08:32 AM
Formula to figure credit card payments Joe Gieder Excel Worksheet Functions 1 March 24th 05 03:56 AM
Calculating credit card debt, interest , and payments deeosu Excel Worksheet Functions 1 February 18th 05 08:20 PM
How do I do a MOD-10 Credit Card check in Excel? Stephanie Excel Worksheet Functions 3 February 17th 05 11:03 AM
finance charge on credit card min Excel Worksheet Functions 1 November 1st 04 02:37 PM


All times are GMT +1. The time now is 10:30 PM.

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

About Us

"It's about Microsoft Excel"