1E+05

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

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
 
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
Click to expand...

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
 
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
-------------------------------------------

 
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.
Click to expand...

Thanks. That answers the second part of the OP's question. It's a bit tricky
to set the column to just the correct width to convert the 100105 to 1E+05, but
I did it.




--ron
 
Thanks for the responses, but I'd already figured out that I just needed to
make the column wider! I'd already entered similar data on three other
worksheets without a problem, so that hadn't occurred to me until I realized
that on this fourth worksheet the column was too narrow.

Andrea

: 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
:
:
 
You didn't believe me when I said that 6 hours ago?<g>
Click to expand...

I hadn't seen your response when you posted. I note our posting times were
only a minute apart.


--ron
 
Back
Top