>>BTW, one thing doesn't work in Excel - I'm writing one column which contains a string, which is used as an index into a lookup table on Sheet2. If this string begins with an alpha char, it works fine; if it contains digits only, the lookup formula returns #N/A. Formatting whole column as text doesn't help. Sometimes pasting the same number from another cell with the same value helps, sometimes it doesn't. Don't have a clue why does it do this.
>>
>>I've heard there should be some chr(?) to prefix such fields, to have Excel accept them as text containing digits, and not as a number, but wouldn't know which one.
>Dragan,
>For such situations to be sure I precede them with a '
>Cetin
Just an apostrophe? Gee, I thought I'll have to try with all control chars first. I could have remembered that one from the dim and distant days of 1-2-3 or VIP (the same, just for the Atari).
Thanks, I'll try it right away.