I'm transfering data from Access to Excel and I am having trouble forcing the date to format as example: Oct-07. I used the format in Excel, but it keeps converting to 10-07-2009 even through its correct in Access. My thought is to use code to force it. Need help with correct format.
'Force MM-D format
objSht.Range("E7:Q155").Format ("mm d")