Anthony Chilco wrote:
Hi Jerry,
The apostrophe tells Excel to treat the number 10 as text.
If you load the file in Excel and select the cell, you
should see the apostrophe in the edit box at the top of the
sheet. When I load an excel sheet with '10 in a cell, I see
only the 10 in calc. The edit line shows the apostrophe. I
couldn't find any entry in options to turn on the display of
the apostrophe.
tc,
I think the OP is saying that he's got numbers in his Excel document (so
they don't have an apostrophe to start with--they're used in
calculations and the like) and they turn up as text with the apostrophe
when he opens that doc in Calc.
If that's the case, Jerry, I don't know the answer, but I hopefully will
have made the question clearer. Please correct us if we've made wrong
assumptions.
Good luck,
Kira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
