I exported a file from a web based Lotus Notes database. When I open the
file in Excel 2003, 1/2 way down in the file, Excel converts the numbers to
text. If I open the file in Excel 2000, all numbers are imported as numbers.

I can use the multiply by 1 option to convert the text to numbers, but then
I lose some formatting.

If I only export a portion of the database, all the numbers are imported as
numbers.

An interesting side bar is that if I open Excel 2003 with a file that has
1/2 the numbers as text and the other 1/2 as numbers and then open a partial
extract where all the numbers are numbers, the partial extract will open with
all numbers as text. If I then close and re-open Excel 2003 and then open
the partial extract where all the numbers are numbers, Excel 2003 will open
the file with all the numbers as numbers again.

I'd like to determine a way for Excel 2003 to open the extract with all the
numbers importing as numbers.

Any help would be greatly appreciated.