Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default cutting and pasting dates as general text

I work with large databases in xl where the dates are formatted as a day
(e.g. 3/21/08) and I want to reformat the date so that the format is a
general format for month (e.g. "3" or march). I know how to reformat (using
custom format 'm'). Issue is that xl still treats it like its 3/21/08 so
that when I group and sum, it groups on the date rather than the month.

I've cut and pasted to MSWord and then back to xl. That is fine for small #
of records.

Anyone know how to reformat in xl so that I can group and sum (pivot table)
on the 'month' without retyping the info in?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default cutting and pasting dates as general text

I'd keep the raw data as a date.

Then you can group by month in the pivottable.

After you create the pivottable
Rightclick on any entry in the row (or column) field
Choose Group and Show Detail
Then Months (or Years and Months???)






analyzer1 wrote:

I work with large databases in xl where the dates are formatted as a day
(e.g. 3/21/08) and I want to reformat the date so that the format is a
general format for month (e.g. "3" or march). I know how to reformat (using
custom format 'm'). Issue is that xl still treats it like its 3/21/08 so
that when I group and sum, it groups on the date rather than the month.

I've cut and pasted to MSWord and then back to xl. That is fine for small #
of records.

Anyone know how to reformat in xl so that I can group and sum (pivot table)
on the 'month' without retyping the info in?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cutting and Pasting with spaces pm Excel Discussion (Misc queries) 1 September 25th 07 08:32 PM
Cutting and Pasting in Excel Rev. Munchkindad Excel Discussion (Misc queries) 19 September 5th 07 08:40 PM
Date changes when cutting and pasting dates to new workbook /works Alan Excel Discussion (Misc queries) 3 February 14th 07 03:01 AM
Formats when cutting and pasting Kayle Z Excel Discussion (Misc queries) 1 February 9th 06 04:57 AM
when cutting and pasting to different files the year changes... w. excel Excel Worksheet Functions 1 April 13th 05 09:51 PM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"