- Aug 28, 2002
Hey all, I have a workseet that contains a row of numbers that represent dates. The data is formated like this 20040201 or YYYYMMDD all as numbers. I would like to be able to convert it into a real date like March 1st, 2004 or even Mar-01-2004 or something more readable than it is now. I was thinking of using the DATE(day,month,year) function but before I did that I would have to split up my number into 3 columns. is there a way to take my big date number and put the first 4 numbers in column B then the 5th and 6th numbers and put them in column C and then the 7th and 8th numbers in column D? I have tried changing the format in the cell properties and I have also tried using the datevalue() function. I am sure that this is possible somehow but I can't figure it out. Or if you have a different sugestion how I can format the date properly let me know. Thanks for you time.