Issue 125162 - numbers as dates
Summary: numbers as dates
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.0.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2014-06-26 14:14 UTC by occurs-60189
Modified: 2014-10-14 13:40 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description occurs-60189 2014-06-26 14:14:05 UTC
Many times when I enter a number (even a number smaller than 5 digits) in a cell formatted as number, it shows up as a date; if I then delete that entry and re-enter the same number in the same cell it shows as a number (as desired).    WHY?    I typically enter many numbers without paying much attention, then when I look back expecting to see the numbers entered, I instead see dates! That is very frustrating & requires doing double work to correct the problem. The numbers I enter are actual numbers, not formulas that produce numbers.
Comment 1 mroe 2014-10-14 13:40:59 UTC
Please describe step by step how to reproduce this issue.
It could help if you attach a sample spreadsheet where the cells have the used formatting.
Is this issue reproducible with AOO 4.1.1?