![]() ![]() Select "All Files", which appears in the "Files of Type" window, found at the bottom of the "File Import Text" dialogue box. Select "Import Text File" from "Get External Data", found under the "Data" tab. Open Microsoft Excel and leave "Book 1" opened. (The following procedure is appropriate for Microsoft Excel 2000 and the process may vary for other versions of Microsoft Excel) Use the following procedures when importing numeric data created by CardMinder™ into Microsoft Excel. this problem is caused by how Microsoft Excel's settings have been set and not by CardMinder™. "+-5678" is calculated and the result "-6941" appears in the Excel sheet cell. When numeric data contains mathematical symbols (such as + and -), the number becomes a mathematical expression that the Excel sheet calculates.Į.g. "0"s appearing at the beginning of a numeric figure are deleted.Į.g. The following problems may occur when importing numeric data created by CardMinder™ into Microsoft Excel. Some methods of avoiding such problems are described below (See Countermeasures). This problem is caused by how your Microsoft Excel settings were set. telephone numbers) appearing in the spreadsheet occasionally differs from the numbers printed on the original document. When I create data using CardMinder and import that information into Microsoft Excel, numeric data (e.g. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |