Excel: Pipe Symbols Disappear When Exported to LotusLast reviewed: January 23, 1997Article ID: Q107568 |
The information in this article applies to:
SUMMARYIn Microsoft Excel, when you are working with a Lotus 1-2-3 sheet that contains pipe symbols (|), if the pipes are used for display purposes and are entered as text (label) and they are preceded with a single quotation mark, the pipes will be altered when you open them in Microsoft Excel and then resave them in a Lotus file format.
SYMPTOMSTo duplicate this situation, do the following:
WORKAROUNDTo work around this problem, do the following:
Any combination of Alternate Formula Entry, Alternate Expression Entry, and Alternate Navigation Keys will have no net result on the pipe symbols when the file is saved in a .WK1 file format.
|
KBCategory: kb3rdparty
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |