Microsoft KB Archive/52010

Word: Losing Comma Format from Lotus 1-2-3

PSS ID Number: Q52010 Article last modified on 11-02-1994

5.00

MS-DOS

= SUMMARY =

Microsoft Word version 5.0 does not correctly import comma-formatted numbers from Lotus 1-2-3. Numbers formatted with commas in 1-2-3 are imported into Word without commas and without the correct number of decimal places.

Microsoft has confirmed this to be a problem in Word version 5.0. This problem was corrected in Word version 5.0b.

= MORE INFORMATION =

A workaround for this problem is to format the numbers as currency with the desired number of decimal places. Numbers formatted as currency import with commas, the correct number of decimal places, and dollar signs. Once imported into Word, the dollar signs can be removed with the Replace command.

KBCategory: kbother KBSubcategory: Additional reference words: 5.00 5.00b

=
================================================================ Copyright Microsoft Corporation 1994.