ID: Q169887
The information in this article applies to:
When you type text into a cell of a Profitability Analysis workbook that you create with the Microsoft Small Business Financial Manager 97, the pound sterling currency symbol is replaced by the U.S. dollar sign.
This problem occurs when you do the following:
-and-
To work around this problem, follow these steps:
1. On the Edit menu, point to Clear, and then click Contents.
2. Retype the value (not text) in the problem cell.
NOTE: The following Microsoft Visual Basic for Applications run-time
error message appears:
Run-time error '13':
Type mismatch.
3. Click End.
The value is reformatted with the correct currency symbol.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
Additional query words: XL97
Keywords : kbtool xlsbfm
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: November 1, 1998