wrote


We have developed an application in VB6. This application exports some
results to Excel. The Excel displays error "The number in this cell is
formatted as text or preceded by an apostrophe".

Just as a guess, have you tried preceeding the cell contents with an = sign?

My guess is that if it thinks its a function, perhaps it will do the right thing
with your number....

LFS