Thanks for this, i think you are an EXCELLENT teacher and trainer. I will try this from my QB desktop One question on excel. I have officer 365, when I double click or right click on an excel file in windows explorer, Excel opens but the file itself does not. i get a blank worksheet. i can drag the file to the blank sheet and it opens , but no other way. used to open at a click last year. Thanks ! David
Thanks! I'm glad this was helpful for you. Usually this happens to me before I click "enable edit" which shows up at the top of the page. See if that works!
Thanks for this. One note regarding dates: I think if you change QB to use the international, sortable date standard yyyy-MM-dd, then you won't have to monkey with it in Excel. The reason this is a standard is that if you use yyyy-MM-dd in folder names, filenames, spreadsheet data, etc then dates always sort correctly.