Problem formatting dates in cells

  • Thread starter Thread starter Pattylou
  • Start date Start date
P

Pattylou

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?
 
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))
 
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 :-)
------------------------------­------------------------------­----------------
 
Back
Top