Web Form Software from logiforms.com logiforms.com - Easy-to-Use HTML Form Software for building order forms, Email Forms, secure forms and other web forms. Our web-based form builder makes building online forms easy. No Programming Required. Build your Order Form or Secure Form in minutes. No HTML required.


Excel Truncates the Last Digit of a Credit Card


Excel has a known issue when opening CSV file, it automatically determins the column type and in the case of columns with credit card numbers, it can truncate the trailing number. The steps to work around this are:

1. Export from logiforms to CSV format.
2. Open Excel, on the Data menu, choose Import External Data, then Import Data. Browse to the CSV file, and click Open. This brings up the Text Import Wizard.
3. In step 1, select Delimited.
4. In step 2, check Comma; this previews how the data will be separated. In step 3, you can select each column in turn and choose a format.
5. Choose Text for that credit card number field, and youâ??ll get all 16 (or however many) digits, not truncated to zero.

Keywords: import,export,excel, 0, truncates,truncation,corruption,process credit cards,ccnumber,output



Return to KB Article Index


Sign up now and get FREE "10 Steps For Creating Stunning Web Forms That Get A Response -- Quick And Easy"

PDF Form Population
HACKER SAFE certified sites prevent over 99.9% of hacker crime.

Have a specialist contact me
Call 1-866-403-8464 in USA or 1-206-384-4671
Join our Monthly Newsletter
A great Resource for web masters with valuable tips on building your online business.




"In a short time we had a great end result and I am totally satisfied with what Logiforms did for the Carolinas PGA and our membership survey."

Ron Schmid, PGA
Executive Director
Carolinas PGA Section


"The Auto Responders allow us to send an instant, personalized message to users submitting the forms. We are able to include all of the form fields in the autoresponse email, which allows for maximum personalization."

Douglas Mortensen
President
LifeGoals Corporation


Web Design Resources
Check out these other great sites.



Home | Form KB | Affiliates | Affiliate Login | Features and Functionality | Support | Privacy Policy | Terms of Use | Contact

Copyright 2008 logiforms