convert date to text month
i want to make a pivot table with the months as col headings.
my raw data looks like this:
col a col b col c col d
date -- account cost center amt
i have tried formatting col a as date (Jan 01, Feb - 01, etc) but when i
try to put the data into a pivot table with the dates as the col heading, the
pivot table ignores the Jan -01 format and puts each date as a col heading.
i know that i could sort the data and manually put in "Jan" for all the dates
between 1/1 and 1/31 but i have man...PST file
i pasted my old pst file from my other computer into the
same folder on my new computer. Now it says it doesnt
recognise it as a personal folders file and wont even open
outlook up. I dont know what to do. Can anyone help please?
What versions of Outlook are we talking about here?
Tips of the month:
-Setting Permissions on a Mailbox
-Create an Office XP CD slipstreamed with Service Pack 3
"Emma" <firstname.lastname@example.org> wrote in message
>i pasted my old pst file from my ...Excel
I have data in multiple colums that has been subtotalled by the sum function.
I now wnt to copy and paste or export only the rows containing the subtotals
to a new sheet. When I do this I get all the rows! It does work if I use the
CNTRL key to mark all the individual cells and then paste values only but I
find this a dreadful solution. Surely there is an easier way?
click the 2 in the outline box to hide the data rows
Highlight the range of subtotals
F5>Special>click on visible cells only
> I have data in mul...Associate A File
Could someone tell me the steps to Associate a file (.pps) so I can open it
in windows live mail.
Assuming you have PowerPoint or PowerPoint Viewer installed:
1. Download and save the attachment on the desktop.
2. Right click on the saved file.
3. Select: Open With from the pop-up menu.
4. Click: Choose [default] Program.
5. Select: PowerPoint or the PPViewer.
6. Check: Always use the selected program to open this kind of file.
7. Click OK.
If it still does not open directly from WLMail:
Unable to open .PPS attachments ...Parsing Names in Excel
I have a list in Excel from A1:A100 with names like the ones mentioned
Michelle Fooo (michelfoo@exchange.SASMOM.com)
Myhaass Smith (mysmith@exchange.SASMOM.com)
I want to parse them using string functions to the following format
Any ideas how to do this using a formula?
Thanks in advance
Are you wanting to strip all the name out too or just remove the exchange.?
If the latter just use edit>replace What:=exchange. and leave the with blank
Microsoft MVP - Excel
nick_...How can I increase the character capcity of an Excel cell?
The current maximum is about 1,100.
Excel can hold 32k characters of text and around 1000 in a formula. You
can't change this fact of life.
"Steve" <Steve@discussions.microsoft.com> wrote in message
| The current maximum is about 1,100.
You can increase the ability of the cell to *display* more characters (cell
can *contain* approx. 32,000) by strategically inserting forced line breaks
(<Alt> <Enter>) within the text.
Please kee...Export To Excel
Enquiry/Sales/Transaction by Debtor
I want to export data from that form to Excel.
I put one Button on this form (Export To Excel) With Code:
run report 'RM Transaction Inquiry Report' destination false, false,
And when I click on this Button I get This Report but without informations
in Report Header.
Debtor ID, Document Number, Document Date, Ranges From To....
When I Click on the printer Icon and choose text file I Get Full Report.
Does anyone know where is the problem?
...can't open files with a # sign in the title
Operating System: Mac OS X 10.6 (Snow Leopard)
I just got a new imac and when I try to open files with a # in the title excel opens but the file won't appear. <br>
if I remove the # from the title it opens again
We've had this discussion very recently in the Word discussion group.
The conclusion was that this mechanism seems to work fine in Office
2008, and that it is generally not a good idea to include special
characters, such as "#", in a file name. Sorry if this doesn't really
On 17/02/10 2:45, guitar5@o...Upload Multiple Files Failure
when I try to upload multiple file to a SharePoint Doc Library I get
the following error:
Cannot run Windows SharePoint Service on this page: "https://
The SharePoint Deployment is with an ISA server (not sure if this can
I can Upload a single file, but not multiple...
...returning to file previously worked on after closing it.
Operating System: Mac OS X 10.6 (Snow Leopard)
In Appleworks, whenever I returned to the file I had been using (eg the manuscript I had been working on) the last page I had been editing would open up. But in Word, it always opens at the first page of the document and i have to scroll down many pages to reach the page I had been last working on. <br>
Is there a short cut?
A couple of the simplest & most direct solutions:
Once the file opens key Command+End. If using a laptop or compact keyboard
you may need to use the fn key along with that.
...Excel 2002 & 2007 ?
Is there much different in the Excel 2002 and 2007? I have 2002 and I was
thinking about buying Student Office 2007 for $79 so do you think it would
be worth it?
Is there something that XL 2002 cannot do for you?
Are you prepared to have to re-learn a lot of 'commands'?
Could you wait 6 to 12 months for Office 14?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Richard" <email@example.com> wrote in message
> Is there much different in the Excel 2002 and 2007?...Excel graph 3 sets of data. 2 sets as lines 1 as column?
I have data a bit like below, I am trying to do a graph, which shows the AFR
as columns for A-D, but I want 'water' and 'whole' as seperate lines to show
current scores across the graph. When I do the graph, I get two columns and 1
line. Does anyone know how to get to get the two lines?
A B C D
AFR 0.8 0.6 0.4 0.3
Water 0.5 0.5 0.5 0.5
Whole 0.3 0.3 0.3 0.3
On the chart, select the second column, right-click, select Chart Type from
the context menu, select line chart.
Thanks for that worked a treat, I'll remember that ...Excel 2003
I'm simply brain dead this morning and could use a little help.
I have assembled a column of pointers into a table. These pointers are
simply the row number of the selected data in a table. Assuming that this
column starts in A01, I would like to create a formula in B01 that simply
makes B01 equal to the data located in a specified column (use column F for
the example) in the row specified by A01.
I remember doing this before, but it just excapes me this morning.
Thanks in advance for your consideration and help,
Craig Brandt wrote:
...Excel 2003 Macro ignores Arrow Keystrokes
Can't get ANY macro to work!
*ignores relative references
*ignores arrow keystrokes
*ignores use of F2
*only offers VB for editing
Macro security is low, there is no protection.
Madness is near, help, please!
...Sorting in Excel
I have in sheet1 in Excel 5 columns with data. The A column has names, the
B age, the C skills, the D salary and the E a code number (as text).
Every few days I add some new names at the end of A column (also the other
data in B,C,D,E) and sometimes I delete a few names.
I would like to find a formula to transfer all those data in sheet2, exactly
the same way, but in ascending order by the name.
(With few words I try to find a way to auto sort and transfer some data.)
I would do this by writing a macro to:
1. Clear space for a sorted copy of your table.
2. Copy the ...Microsoft Excel is waiting for another application to complete an OLE action
I have MS Office 2004 running on a Mac Powerbook with OSX 10.4.3 on it.
I have an Excel spreadsheet that has an embedded Word document in it.
If I click on the box, the cell value is: EMBED("Word.Document.6", "")
When I dbl-click on it, I get the spinning cursor and this message that
says, "Microsoft Excel is waiting for another application to complete
an OLE action." with just an OK button is displayed. When I click on
OK, the message goes away and then comes back after a few seconds.
We have 2 other computers running MS Office on OSX 10.4.3 where this
works ...excel 2003 05-27-10
Hi I am using excel 2003 and everything was goin g fine until I tried to open
a file (which was working ok) but now won t open and just comes up with the
"Time Sheet 09-10.xls:file format is not valid" any ideas on how I can
either re save so it will open or any other ideads on how I access the info
You may want to try it on a different computer -- or even a different version of
Or you may want to try OpenOffice.
A few people have said that OpenOffice.Org has been able to open files that
http://w...Create / Update DL in GAL using data in an Excel sheet
I work at an organization where we have 2 data sources. Unfortunately, the
AD source is not authoritative and actual data comes from our HR system.
We create the DL's in GAL in AD / Exchange using this HR data. This is a
manual process without any automatic feed into the AD / Exchange system.
Consequently, the DL's are usually out-of-date for long periods until
someone does the whole process again.
I want to know if I can write a script (or something similar) that will
create / update the DL's based on the input data that I provide in an Excel
sheet (or a CSV file or simil...Saving html file
I have a 4-page publisher document that I want to save as
an html document. When I do this, I end up with a file
with the html extension as well as a folder containing all
Also, I will eventually ftp the 4-page document to a
website. I'm not sure how to do this with one file, and
one folder full of images?
Any guidance for this new user who has been thrust into a
job with no experience?
I have uploading directions on both http://www.davidbartosik.com and
Also in the future use the web forum for web help -
microsoft.public.publisher.w...OT:Learning excel question
I had a previuos maniac post, but I'm OK now.
I have some Excel 2000 MS books, Would I be wasting time using these to get
a better (any) grip on excel 2003? I guess I mean has it changed that much?
No it hasn't changed much at all, just a few cosmetic changes, a 2000 book
(No private emails please)
"Frank" <stratster68@IHATESPAMworldnet.att.net> wrote in message
> I had a previuos maniac post, but I'm OK now.
> I have some Excel 2000 MS books,...problem accessing file
recently i made updates to my microsoft money file. After updating the file,
i exited money, without backing up the file (bad idea). Once I exited, i
changed the filename in windows explorer (using rename command). When i
attempted to open the file again, money gave the following message: "Money
will update your file with the latest improvements." In other words, it
treated like a file from an old/different version of money. Then it said
"Money cannot locate 'My Documents\my money 040809.mny' or cannot open it,
possibly because it is a read-only file or you d...Outlook files on Active Directory
My company is installing active directory on a company wide server,
all E-Mail messages will reside on the server. The question is can I
move an E-Mail on the active directory to a local .PST or other file
within the folder list of Outlook 2002 SP-1
...PDF files in Outlook XP
I recently upgraded Acrobat Reader to 6.0. I'm running Office XP SP3 in
Windows 2000. Since the upgrade, pdf attachments sent to me have generic
icons and the file cannot be opened unless I save it to disk first. I
receive many of these daily and saving to disk is not efficient time-wise.
Is there a fix or patch that will allow me to open these pdf files? I did
not have this problem with Acrobat 5.0.
Reinstalled Adobe Acrobat already? File associations are not done by Outlook
but are managed by the program that supports it itself. You can overrule it
by going to Control Panel-...Excel cannot access..
Very important accounting(which is 26 KB only) excel file is not
allowing me to open the file. I may encrypted this worksheet and
immediately turned into green colour, 6 months later i reinstalled
windows XP pro but this time iwhen i try to open
First dialog box show that : Excel cannot access "file name". The
may be read-only or encrypted.
Then second dialog box show up : Cannot access "file name".....
i tried openoffice.org but didnt solve the problem.I never used any
password for this file.
I think this excel file ,when i choose the option to encrypt ...eField Service RMA Help Files
Has anyone else run into a problem where the help icons on the application
windows of Returns Management will not open the appropriate help information?
I spoke with another consultant and he said that this happens to him only on
the Field Service Modules. I think that there has to be a better answer or a
fix that I am missing.