Bored at work? Make some nuz...

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact | Forum

|

Data Worker Exchange

»

UK date & time formatting

View: New views

1 Messages — Rating Filter: Alert me

UK date & time formatting

by JDR123 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I currently have a column of UK date and time values in the form of 14/06/2005 17:00:00. In order to create a Pivot Table followed by a Pivot Chart that analyses the sales data by month and year only, I need to loose both the day and time sections of the field. I can do this by DigDB>>Column>>Split, but the resulting month and year fields are now not recognised as dates. I've tried re-formatting them as such but can't get the darned things to work. Any ideas anyone?

Features | Testimonial | Download | Purchase | FAQ | License | Contact | Forum (powered by Nabble's free forum)

Copyright © 2006 All rights reserved

DigDB Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.