Earl
Sun Jun 20 15:52:36 CDT 2004
Actually, the date Jan 1, 1905 is represented by the number 1828. Do Edit -
Clear - Formats, and you'll see that number. It will appear as 10105 only
if formatted mddy or mddyy.
You might see 1E+05 if you've accidentally entered something like 100105,
and the column is too narrow to hold it in its straight decimal (100105)
form. Widen the column, and it will probably revert to 100105.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"Ron Rosenfeld" <ronrosenfeld@nospam.org> wrote in message
news:68mbd0h8sg0h75at34si5iio53ruqrlov7@4ax.com...
> On Sun, 20 Jun 2004 14:01:36 -0400, "Andrea" <andreanospam@acox.net>
wrote:
>
> >I'm entering data into an Excel worksheet (Office XP using Windows 98SE).
> >For one column I want to add the dates of birth, which I'm entering as
> >mmddyy. For some of the cells in that column (but not all), although I
enter
> >it in that format, it ends up saying 1E+05. I went back and made sure
that
> >the cells were formatted the same--general--and they are. I even deleted
the
> >column and then re-entered the data in a newly created column, with the
same
> >result for the same cells. Why is this happening, and how can I fix it?
TIA.
> >
> >Andrea
> >
>
> When you enter a number of the form mmddyy, such as 010105 for Jan 1,
1905,
> excel does not interpret it that way. It interprets as the number 10105.
>
> To enter dates that Excel will recognize as dates, you need to use your
system
> separator and enter in the correct order. For US settings, that would be
> 01/01/45 for Jan 1, 1945.
>
> Otherwise you will need to translate your entry using VBA or, possibly,
the
> Data/Text to Columns wizard.
>
> I don't know how you are getting a value of 1E+05 entering a date, though.
>
>
> --ron