I am a new user who is having an issue with trying to insert a date value. What is happening is when I attempt to insert a date I get a number returned instead of a date. For example when I try to insert the date 1/1/1900 I get 2. I have tried formatting the cell through excel into a date but I still get the wrong date of 1/2/1900. This, however, is not true with all the dates. With the date 11/30/2005 I get the value 38686. Any suggestions on what this issue can be would be very appreciated.
Thanks in advance
Date
Votes
3 comments
-
Jet Reports Historic Posts If its any help that number matches the date :)
Sounds like something weird is going on for you. I am able to type in the number and format it to Date and vice versa via the 'Format Cells' options, nothing special required.
Only thing I can think of is your regional setting on your PC may be dd/mm/yy instead of mm/dd/yy. Under XP they are in the control panel, under Regional and Language Options.
cheers- Mark -
Jet Reports Historic Posts Yah shortly after I posted this I figured out it was just a numeric representation of the date. The part that threw me off is why 2 isn't translating to 1/1/1900 while the other numbers switch over to the correct date. It shouldn't be a crucial issue since the 1/1/1900 is just a default value but something I would be interested in figuring out if anyone has an idea.
Thanks for the reply -
Jet Reports Historic Posts it also happen to me most of the time. you can try using the excel function =text(cell ref,"mm/dd/yyyy"). this will translate your numerical value to date
Please sign in to leave a comment.