| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel - pivot table - how do i format cells with data mm/dd/yyyy .
i have base data in the format of mmddyyyy hhmmss that I'm putting into a
pivot table. How can I format the Pivot Table fields to show mmdd so only one entry shows for a given day? 'format\cell\mmdd' does not work |
|
#2
|
|||
|
|||
|
Dave
Untested, but could you not group your dates into "Days" -- ----- XL2003 Regards William "Dave" wrote in message ... i have base data in the format of mmddyyyy hhmmss that I'm putting into a pivot table. How can I format the Pivot Table fields to show mmdd so only one entry shows for a given day? 'format\cell\mmdd' does not work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Summarize by "Median" in the Pivot Table Field for Excel | Excel Worksheet Functions | |||
Linear Mode
