The Beaver wrote:
In Calc when I type in a number like a part number, it automatically
destroys my entry and makes it a date. I tried changing the format to
number and it still ruins the spreadsheet by making the part number a
date. It seems to work correctly if I format the part number column
as text, but if Calc automatically turns all numbers to a date, it
will have no useful value as a program. I never had this problem with
2.4
Floyd
Floyd -- As Brian said, it would help greatly in understanding what is
going on if you could give examples of the part number being changed to
a date.
Calc certainly doesn't turn all numbers into dates, like you claimed. If
your version really does do that, there is clearly something amiss.
And as was stated, it sounds like you've identified the solution --
format the part number column as text. Part numbers should be treated as
text anyway. It wouldn't make any sense to perform numerical
computations on them (like adding up a column of part numbers, or
multiplying the part number by 2, etc.). Kind of like phone numbers --
other than being composed of numbers, there is no real numerical meaning
to them. You wouldn't multiply two of them together, divide one by the
other, add 10 to one of them, etc. and expect them to have any meaning
as a phone number any more.
So it would help if you replied to the list and gave examples of the
part numbers that are being changed. Although it sounds like your
problem is solved (format as text), so assuming that continues to
prevent your problem, there may be no more need to give any specifics.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
