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.
