Word 2003 and Excel formatting

B

Bremser

I'm creating an Excel-based order form. I'm trying to copy and paste a
2-page word document (contract text) into 2 contiguous worksheets in Excel.
The first page comes over fine. However, when I copy and paste the second
page, the numbering reverts back to 1 (instead of the 5 that starts that
page).

How can I keep the numbering scheme when copying over to Excel?

Thanks!

Bremser
 
A

Anubix

Wasn't able to replicate the problem. but, it sounds like Excel is not
keeping the autonumbering setup in Word. Can you convert the numbers
to plain text? I have a macro that will do it. First, Save your
document as a new one for testing purposes. Then, select the whole
thing and apply this macro:

Sub ConvertNumberingtoText()
'

' converst automatic numbering to text
'
Dim lp As Paragraph
For Each lp In activedocument.ListParagraphs
lp.Range.ListFormat.ConvertNumbersToText
Next lp

End Sub
 
Top