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.
From help:
If you decide to enter a number directly as text, enter an
apostrophe (') first. For example, for years in column
headings, you can enter '1999, '2000 and '2001. The
apostrophe is not visible in the cell, it only indicates
that the entry is to be recognized as a text. This is useful
if, for example, you enter a telephone number or postal code
that begins with a zero (0), because a zero (0) at the start
of a sequence of digits is removed in normal number formats.
tc
You appear not to be subscribed to the users mailing list.
You could miss many of the replies to your post unless you
do subscribe. Just send a blank message addressed to
<[EMAIL PROTECTED]> using the e-mail account
through which you want to receive it. You will receive a
message asking you to confirm your subscription by replying
to it. See http://support.openoffice.org/index.html for more
options.
Jerry Biggerstaff wrote:
Open Office Calc is opening Excel 2000 files with some of the numbers
importing as lables (Format of cell in Calc is '10). When I open the
same file in Excel, the ( ' ) is missing in the same cell. I have been
trying to get away from Excel but this problem has me stumped and stopped.
Just removed 2.0.1xx and installed 2.0.2. Same problem.
Any ideas are welcome as I am retired and on a very limited budget and
M$ has priced the latest Excel/office out of my budget.
If allowed, please reply directly to my personal email. If not allowed,
please let me know how to get any answers to my question.
Thanks,
Jerry B
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
