Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

excel date format problem

Comment:

This should be extremely basic, but for some reason, I cannot make this work. All I want to do is format a column to turn numbers I type into dates. I highlight the column, go to format cells, choose date, then select the 3/14/01 format. As I understand, if I type in the numbers 31401 in that column, it should automatically produce 3/14/01. However, it does not. Rather, it gives me 12/20/85. As another example, if I type 21704 I get 6/3/59. This is driving me INSANE--does anyone know what the problem is???

Name: Mike (by mmcconaghy)
Date: March 20, 2009 at 08:40:36 Pacific

Reply:

You need to use the slash, otherwise it thinks your putting in a number, which it then converts to a date. MIKE

0

Time to Decimal

Decimal to date in excel

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have several large trade blotters I exported from our portfolio trading platform. Problem is, with the date, when it exports to excel, it exports the date as a single integer. For example, 05/15/20...

Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,there is no such an option in Format --> Cell --> "...

Summary: When I try to format a cell(s)I can open Format but when I click on cells it won't open. I get no error message. I have had other strange things happen in excel - date format disappears and the curr...