[mso] Re: Excel 2002 - Pivot Table Formatting

Thanks Diane, I did solve the problem eventually.  I was
formatting both the source data and the pivot table, but
what I didn't realize I was doing when I was formatting it
in the pivot table, was that I wasn't formatting all the
data because I was using the page feature to filter what was
displayed.  Once I clicked on the page data and had it
display all, and then formatted it to the correct format, it
stayed formatted properly when I filtered the data from the
page data.

And this from someone who is giving an hour presentation on
the basics of pivot tables next week.  Guess that's more of
the intermediate topic. <g.

Thanks for the help and enjoy those pivot tables.

Christine

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx
[mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Dian Chapman
Sent: Wednesday, January 28, 2004 4:43 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2002 - Pivot Table Formatting


Are you setting the formatting in the spreadsheet OR the
Pivot table? If doing it in the spreadsheet...try doing it
in the Pivot table. Select the data, right click and click
Format Cell. Set it to TIME and then set the format within
that dialog. Then refresh the pivot and see if that holds.=20

(Yes, Linda...me and ye ol' pivots are becoming good
friends!<g>)=20


Dian D. Chapman
Technical Consultant, Instructor
Microsoft MVP & MOS Certified

Free Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html
Learn VBA the easy way, thru video!
www.mousetrax.com/techcourses.html

 =20


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx
[mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of McDonald,
Christine, Ms, DCAA
Sent: Wednesday, January 28, 2004 4:43 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel 2002 - Pivot Table Formatting

In my data source for the pivot table, I have cells
formatted as hh:mm to show hours and minutes, such as 1:05
meaning 1 hour and 5 minutes. When I create the pivot table
using this field as part of the row data, it sets the format
to 1:05:00 AM, changing the underlying format to hh:mm:ss
am/pm.  I change the format on that particular set of data
in the pivot table back to hh:mm, but as soon as I refresh
or change the pivot table it reverts back to hh:mm:ss am/pm
format. If I set the format on the data to general and type
in 1:05, it displays 1:05:00 AM. =20

Is there anyway to have it stop reformatting the cells with
data is refreshed or updated.  I have different pages of
data to display, so it gets changed often.

Thanks,

Christine McDonald
Technical Specialist
Western Regional Office


************************************************************
*
You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to
mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe"
(without the quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.
This will also allow you to change your email settings to
digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with
the group, send a request to mso-moderators@xxxxxxxxxxxxx
and you will be sent an invitation with instructions.  Once
you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
************************************************************
*

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date:
1/19/2004
=20

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date:
1/19/2004
=20

************************************************************
*
You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to
mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe"
(without the quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.
This will also allow you to change your email settings to
digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with
the group, send a request to mso-moderators@xxxxxxxxxxxxx
and you will be sent an invitation with instructions.  Once
you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
************************************************************
*


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: