 |
|
FAQ - fi-4110EOX2 |
|
 |
When I create data using CardMinder™ and import that information into Microsoft Excel, numeric data (such as telephone numbers) appearing in the spreadsheet occasionally differs from the numbers printed on the original document. |
|
|
|
 |
This problem is caused by how your Microsoft Excel settings were set. A few methods for avoiding such problems are described below. (See Countermeasures).
[Problems]
The following problems may occur when importing numeric data created by CardMinder into Microsoft Excel.
- "0"s appearing at the beginning of a multiple digit numbers are deleted.
e.g. "03123456) becomes 3123456 on the Excel sheet (See figure 1)
- When numeric data contains mathematical symbols (such as + and -), the number becomes a mathematical expression that the Excel sheet calculates.
e.g. "+1-030-1234-5678" is calculated and the result "-6941" appears in the Excel sheet cell.
Note: this problem is caused by how Microsoft Excel's settings have been set and not by CardMinder™.
[Countermeasures]
Use the following procedures when importing numeric data created by CardMinder" into Microsoft Excel.
 When importing CSV format data into Microsoft Excel.
(The following procedure is appropriate for Microsoft Excel 2000 and the process may vary for other versions of Microsoft Excel)
- Open Microsoft Excel and leave "Book 1" opened.
- Select "Import Text File" from "Get External Data", found under the "Data" tab.
- Select "All Files", which appears in the "Files of Type" window, found at the bottom of the "File Import Text" dialogue box.
- Select the CSV file you created with CardMinder™.
- Choose "Delimited, Characters such as commas or tabs separate each field" from the "Original data type" section of the "Text Import Wizard-Step 1 of 3" dialog box and then select "Next>".
- Select "comma" from the options appearing in the "Delimiters" section of the "Text Import Wizard-Step 2 of 3" dialogue box and then click "Next >".
- Choose "Text", located in the "Column data format" section of the "Text Import Wizard-Step 3 of 3" dialog box, to specify the number of digits for the column in question. (The "Column data format" section is located in the upper right hand corner of this window) Then select "Finish."
- When the "Import Data" window appears, select "New worksheet" and click "OK."
- Make sure that numeric data has been correctly imported into the Excel sheet.
When importing TEXT format data into Microsoft Excel.
(The following procedure is appropriate for Microsoft Excel 2000 and the appropriate process may vary for other versions of Microsoft Excel)
- Open Microsoft Excel and leave "Book 1" opened.
- Select either "Import Text File" from "Get External Data", found in the "Data" pull down menu or "Open", found in Microsoft Excel's "File" menu.
- Choose "TEXT files" from the "Files of type" window appearing either at the bottom of "Import Text File" window or "Open···" dialog box.
- Choose the TEXT file you created with CardMinder™.
- Choose "Delimited, Characters such as commas or tabs separate each field", appearing in the upper portion of the "Text Import Wizard-Step 1 of 3" screen and then click "Next>."
- Choose "Tab", found in the "Delimiters" section located in the upper portion of the "Text Import Wizard-Step 2 of 3" and then click "Next >"
- Specify the number of digits for the column in question in the "Text Import Wizard-Step 3 of 3" dialog box. Then, select "Text", found in the "Column data format" and click "Finish."
- When the "Import Data" screen appears, choose "New worksheet" and click "OK"
Note: This screen will not appear if you chose "Open" during the first step.
- Make sure that numeric data has been correctly imported into the Excel sheet.
|
|
|
 |
 |
|
|
|
