I am running Excel 2010. When I export my P&L from Quick books in to excel I am not able to group the dates from days to months. I am at a loss as I have done this before.
I am running Excel 2010. When I export my P&L from Quick books in to excel I am not able to group the dates from days to months. I am at a loss as I have done this before.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
however, check your source dates which should be in Excel Date format not as text (Date is a number)
L M 1DATE format General format 2 21/05/2018 43241
Last edited by sandy666; 05-20-2018 at 06:58 PM.
You are probably dealing with text dates - that often happens with data import. Do a quick test =isnumber(cell-ref)...FALSE indicates TEXT and we will need to convert them
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks