Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem formatting dates in cells

0 views
Skip to first unread message

Pattylou

unread,
Nov 24, 2007, 8:09:00 PM11/24/07
to

when I select a column and go to format cells, number, date, and any format
of a date
and then type in a number in a cell as 101507 - it comes up in the cell as
11/29/77
or November 29, 1977. Any suggestions?

Gary''s Student

unread,
Nov 25, 2007, 9:12:01 AM11/25/07
to
That is correct. 101577 expressed as a date is:
11/29/2177

that is not want you want. If you want 15 October 1977, then in another cell:

=DATE(1900+RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))

--
Gary''s Student - gsnu200758

Ken Wright

unread,
Nov 26, 2007, 5:41:20 PM11/26/07
to
You cannot enter dates in that format, you need to include the separators.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------


"Pattylou" <Patt...@discussions.microsoft.com> wrote in message
news:69678030-125D-4738...@microsoft.com...

0 new messages