I have to use the subtotal function to gain totals based on the month that a particular item was posted to the GL (accounting stuff) Each row is a separate record. The problem is that when I pull data from our enterprise management system it does not give me information for posting date in a date format. instead it gives something similar to: "07/05/11 17:21:29CSCRI". since I have to sort and subtotal this data based on date, it proves difficult to get the information I need. is there a way to take "07/05/11 17:21:29CSCRI" and turn it into something useful? would it be easier to manually sort by the posting date column and manually create the subtotals?
how to manipulate a column of data to improve subtotal
- Thread starter jrg24
- Start date
Jrg24
Firstly Welcome to the Chandoo.org Forums
Select the Column with the data 07/05/11 17:21:29CSCRI
Goto Data, Text to Columns
Click Delimitered
Check the Space Delimeter
Next
Select the Date Column and set the Type to DMY or MDY as appropriate
Apply
You will now have the dates in their own column to use as appropriate
Firstly Welcome to the Chandoo.org Forums
Select the Column with the data 07/05/11 17:21:29CSCRI
Goto Data, Text to Columns
Click Delimitered
Check the Space Delimeter
Next
Select the Date Column and set the Type to DMY or MDY as appropriate
Apply
You will now have the dates in their own column to use as appropriate