|Thanks Mike, very helpful. |
It sucks that Excel can't record credit card #'s as I type them. I use them occasionally to copy/paste into websites so they can't have spaces. They need to be as-is or else I have to delete spaces, dashes or whatever I add to save most of my text. I can do that however until Excel updates their software. It would be a nice add. "This is Windows 2010 and it was my idea." Add a new format for us citizens of the New Age.
Using TEXT or GENERAL doesn't work as it displays the data in the 4.5557E+15 format. It also changes the 16th digit to a zero as it did in NUMBER format which defeats the purpose of recording a credit card number this way. There just isn't a format for this...yet...
I appreciate your answer though, it pointed me to the exact issue I was frustrated with.