MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date format


Posted by Mike on December 07, 2001 3:24 PM

Is it possible to format a column so that if you enter "120701" it will show up as the date "12/07/01"?


Posted by Jack on December 07, 2001 3:40 PM

Good question. trick is to fromat the column to custom dd-mm-yy or mm-dd=yy if in USA date zones.
If you enter as non formatted then you get a nuber and if you format it goes xx/xx/1930??

Custom formay firts to dd/mm/yy
HTH

Posted by Jack on December 07, 2001 3:41 PM

Good question. trick is to fromat the column to custom dd-mm-yy or mm-dd=yy if in USA date zones.
If you enter as non formatted then you get a nuber and if you format it goes xx/xx/1930??

Custom formay firts to dd/mm/yy
HTH

Posted by BJ on December 07, 2001 9:55 PM

This will work for appearance purposes only as long 6 digits are input. Format custom and use the following format ##"/"##"/"##.

If you're looking to vary the data input, we can create a different solution for you.

Posted by Juan Pablo G. on December 08, 2001 6:08 PM

If you want to work with this data as REAL DATES, try adjusting the tip of the week for Oct 31st.

http://www.mrexcel.com/tip029.shtml

That works very well.

Juan Pablo G.