>>>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
>
>Tried that in the meantime, and it won't do. The field contains the apostrophe, it's visible up there in the edit field, not visible in the cell, and the vlookup() function still returns the #N/A. It does so even with some values which don't originate from VFP, and we're clueless. Must be another Excel glitch. The only working solution is to paste it from a cell where it works.
Dragan,
Might it be that it's opened in a preformatted template and cell has a format that causes it not to show (ie:hidden) ?
Cetin