General thread for MS Excel questions & answers.
My question - how can I convert a number eg 20060410 into a date Excel can understand eg 2006/04/10 ie a number to a date? Formatting for date does nothing. (This date number is exported from Bullcharts, but Excel doesn't seem to understand it as a date?) Formula or macro???? Thanks