Mr. Red

Then your Excel top left cell would have been:

=^quot;&#"&TEXT(ROW(),"0")&";"&""&ROW()&""
?

I haven't figured out what "save as html" is supposed to do in Word. I get a whole lot of garbage that's mostly unneeded.

Try "save as - text only." You can name the "save as" file with the htm extension, or take the .txt default and then change it (rename) in WinExplorer to .htm. Once you have changed the extension to .htm, it should open in IE (or whatever you're using).

The "save as html" may try to code some characters for you, but it does so many other things that I just haven't had the patience to mess with it.

Word includes a "numbered list" or "unnumbered list" format as a clicky on the top tool bar, but I have found these troublesome to use. If this is what you're talking about with "how Word handles numbering," I'd suggest you try something else for most things.

When you "apply" numbered list formatting, Word uses some sort of arcane hypertext device to indent the list, and add a "symbol" for the numbers (or bullets for unnumbered list). You cannot "select" either the numbers or bullets to edit them. (If this is the problem area - suggest you try this in Word to see how it doesn't work). You cannot search and find these numbers or bullets, partly because they are "outside" the text - search can't select them either, - and partly because they are "mapped" to "real sybols" - to use "Wordspeak."

If you want to generate a sequence of numbers in Word in a way that gives you some control, there are a couple of useful "fields" that may be helpful.

If you haven't used fields in Word, I would suggest that first you go to "Tools - Options" and select the "View" tab. In the "show" field, unclick fields, but select "Field shading - when selected."

I generall use a "sequence" field for consecutive numbers.

If you click "Insert - Field" or just type CTRL-F9, you will see a couple of curly braces, with your cursor between them. Type "seq" to start a "sequence" field.

You should have something that looks like { seq| } where | is your cursor.

The sequence must have a "name" - and you can have several working at the same time. Still in the field, type a space followed by some name.

You might have: { seq listnos| }

If you hit F9 now, you should see a "1".

If you copy this, say 5 copies, you will see 5 "1s," but if you highlight them all and hit F9 (field update) you will see 1,2,3,4,5.

If you highlight them all and hit "Shift-F9" (Toggle View Fields) they will open up so that you can see that the code is still there.

If you want to start the series with a number other than 1, you add a "restart" switch \r followed (no space) by the starting number to the first field of the sequence (or to the field where you want to start renumbering).

Put your cursor in the first field (between the braces and add \r125, to get { seq listnos \r125 }
Highlight all of the fields, and hit F9, and you should see 125, 126, 127, 128, 129.

To use the same value twice, you can use the "current" switch \c.
If you change the open second field (Shift F9 to see the code again) to {seq listnos \c }, highlight them all and update (F9) you would see 125, 125, 126, 127, 128.

If you don't take out the final space inside the field, it may print a space, so you should take it out for most uses.
To code to display characters with their character numbers, make one line:

&#{seq listno}; {seq listno \c}<br>

Since html doesn't like tabs, replace the tab with 3 or 4 &nbsp; nonbreaking spaces.

You get:

&#{seq listno}&nbsp;&nbsp;&nbsp;{seq listno \c}

Make a hundred or so copies, highlight the whole mess and update using F9.

Word works fairly reliably up to sequences of 100 or so - maybe quite a bit more with newer versions and a lot of memory, so do a hundred or two, then restart (\r<somenumber>). go to the line above the restart, highlight back to the top and update (F9) and then unlink the ones highlighted by using CTRL-SHIFT-F9. The ones unlinked are no longer part of the series, so you can do the next hundred.

Note that you MUST "unlink" (CTRL-SHIFT-F9) to change everything to clear text before you can post it. And ALWAYS update (F9) before you unlink.

Lots more in word HELP, if you go to "find" and type in "seq." And there are several other "numbering" fields.

Enjoy!

John