Posted to microsoft.public.excel.misc

JerryG

external usenet poster

Posts: 10

Formatting Credit Card #'s with Dashes

I want to format 16 Digit CC#'s as 0000-0000-0000-0000. When I choose
Custom and enter it as I did above or using all # symbols
(####-####-####-####), it magically changes the last digit of the card # to a
zero. Any ideas what is causing this?

For Example:

9990090000092207 becomes 9990-0900-0009-2200

JerryG

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Credit Card Calculation	Joel	Excel Discussion (Misc queries)	1	November 16th 07 03:57 PM
Credit Card form	KA Robertson	Excel Discussion (Misc queries)	0	February 28th 07 03:21 PM
Credit Card Number	raj_srini	Excel Worksheet Functions	2	June 6th 06 06:21 PM
Credit Card #	kmcguire	Setting up and Configuration of Excel	2	June 9th 05 10:18 PM
credit card formatting	tifosi3	Excel Discussion (Misc queries)	6	March 7th 05 05:51 PM

All times are GMT +1. The time now is 11:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us