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")
It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.