[mso] Re: Excel 2002 - Pivot Table Formatting

>Have you tried Pivot Tables in Access yet, Dian? :-) 

Crap...you mean there's one in THERE, too!<sheesh> NOT sure if I plan to get
THAT friendly with Access from the front end. Debating whether it'll be PPT
or Access I use for my final MOS Master cert? Kinda like trying to pick the
lesser of two evils!<smirk> Of course, I WOULD have chosen Excel, were it
not a mandatory expert test!<g>

>Just looooove seeing you answering them Excel questions, girl LOL

HA! I've got a LONG way to go, yet. And since I keep swapping out all our
manual Excel tables for automated Word tables <hee, hee> at work, I may not
get too far for a time!<g>


Dian D. Chapman
Technical Consultant, Instructor,
Microsoft MVP, & MOS Certified
 
Free support: www.mousetrax.com
Free tech mag: www.mousetrax.com/techtrax
Consulting: www.mousetrax.com/consulting
 

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Linda F. Johnson
Sent: Wednesday, January 28, 2004 20:19
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2002 - Pivot Table Formatting

Have you tried Pivot Tables in Access yet, Dian? :-) 

Just looooove seeing you answering them Excel questions, girl LOL


Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine
Free Ebooks and Tutorials
 
*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
it came from me, it did NOT!

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dian Chapman
Sent: Wednesday, January 28, 2004 7: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. 

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


Dian D. Chapman


*************************************************************
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
*************************************************************

*************************************************************
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: