Have you tried saving the Word document as a *.txt file and opening that in
Excel?

The Text to columns Wizard would allow you to designate the data as Text.

Then save as *.xls


Gord Dibben MS Excel MVP

On Tue, 19 Jun 2007 13:28:54 -0700, Lizette Koehler
wrote:

Thanks. That did work. Though have to pre-format my cells text and paste
special text seems over kill.

It would be nice if EXCEL did not require all this work just have text data
stay text data.