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
I opened Calc version 3.0 in Windows XP.
I type some values like 20081018, 20071212, 20070530 into the cells of
an empty spreadsheet. They did not change from numeric to date format. I
typed the value 00081018 and it changed to 81018. All seems normal.
Try it yourself with a blank spreadsheet.
Check the formatting applied to the cells which are changing the numeric
value to a date value with the formatting applied to cells in a blank sheet.
Jim Allan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
