Reply:

no date/time on individual emails in inbox
Hi, Currently my inbox emails are showin up correctly in the "list" view with recipient, title and date and time. However when I click on each individual email they read "sent:none" instead of the date/time. This is just in my inbox, but is a problem when printingor fowarding a copy as they have no date/time on. Have tried uninstalling and re-installing outlook but with no success Any help would be greatly appreciated. Did outlook download the messages or did you import them? What type of email account? -- Diane Poremsky [MVP - Outlook] Outlook Tips:...

How can I change the chart so date is up and down and data is acro
I have a chart that has the date across the bottom (category axis) and the data up the side (value axis). I want to change these. Is this possible? Hi, It depends on what chart type you are using. Have a look at Jon Peltier's example for a line chart. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy speet wrote: > I have a chart that has the date across the bottom (category axis) and the > data up the side (value axis). I want to change these. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info =?Utf-8?B?c3BlZXQ=?= Wrote: &...

Transaction Dates
Bill Gates just can't make it easier can he? Ever since my bank upgraded their software I am having the worst time with e-pay's & x-fers thru money. Can someone help me understand why? When I submit a payment via Money the program tells me it has to change the date because it can't be processed on that day. For example; Today I requested that 3k be transfered from my savings to my checking. In the past the transfer would go thru and there was no issue. Now I get a message that says my bank doesn't have enough time to do the transfer and the date must be modified ...

a valid exchange rate not found for the return date
Anyone ever seen this message? There is no relative help in knowledgebase and what there is - we have covered. Not sure why GP is saying we don't have a valid exchange rate only when doing a return. The return is within the month and the exchange rate table is active for a period long before and long after this date. We've been trying to solve for days now and the error makes NO sense at all. Please help ...

date shows none in out of box
Cannot send e-mails, I can compose an e-mail and it goes into the outbox but will not send. The date shows none in the outbox. Every e-mail I compose goes into the outbox but the date shows none. Please advise Michael wrote: > Cannot send e-mails, I can compose an e-mail and it goes into the > outbox but will not send. The date shows none in the outbox. Every > e-mail I compose goes into the outbox but the date shows none. > Please advise Version of Outlook? Type of Mail Server? If pop/imap, does it go if you do a Send/Recieve? Did it ever work? Any known changes between i...

Text Field
I have created a database using linked tables. There are no notes fields in those tables and I need one. I created a text field and entered a comment but that comment appears against every record but I want it to stay within the record it was recorded against. Anyone help ? Hi KC Where did you create the text field? Since the table is linked, you need to create the text field in your data source, where ever the tables actually reside. If you created the text field (box) on a form, it will not be bound to a particular record and thus it will show up for all of the records, similar to ...

Add Date
We have a spreadsheet that we would like to automatically add the date in the first cell of each row when information is entered into another cell in that row. The date would need to remain static once added. Any suggestions? This worksheet_Change event will update the date in column A each time there's a change anywhere else in the row. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim myCell As Range Dim myRngToCheck As Range Dim myIntersect As Range With Me Set myRngToCheck = .Range("B1", .Cells(.Cells.Count...

insert text data using function
Hi Guys, I need help on the following matter. Suppose i have two column A and B. Now when i insert some text in the A1 cell i want the data automatically set up in the B1 Cell. Fox example if i type Linux in the A1 cell "Open Source" will be automatically inserted in the B1 cell but if i insert windows "close source" will be inserted autoamtically. I tried with if function but no success. How can i achieve that? Mosaddeq Aziz You need to set up all of your possible data entry values for column A on Sheet2. Then in column B on sheet2, put the values you want aut...

CListCtrl large icons and text problem
Hi, I have a simple thumbnail view control based on CListCtrl and description of each item is a 3-line text. Unfortunately CListCtrl shows only two first lines, and the third one is visible only for selected item. How can I show 3 lines of text for all items ? How can I increase label width ? Thanks in advance, Kamil Karmil, Here is a control that might do what you'd like. Tom http://www.codeguru.com/listview/ReportCtrl.shtml "kamil" <kamildobk@xxxpoczta.onet.pl> wrote in message news:OndTGoS4DHA.3360@tk2msftngp13.phx.gbl... > Hi, > > I have a simple thum...

Text Box in Publisher
I am trying to create a text box in publisher with the measurement of 5.75 (h) x 5 (w). But publisher is making the height 5.751. How do I correct this? Is this even possible. Don't think it is possible... The .001 is so tiny it shouldn't make much difference. I can get a true 5.75 in Publisher 2000 but as soon as I copy/paste it goes back to 5.751 in 2002, 2003 and 07. Lines do the same. I can create a rectangle in a draw program, paste special into Publisher, ungroup, this rectangle will maintain the correct size. -- Mary Sauer http://msauer.mvps.org/ "Nikki" &l...

Is there a way to automatically resize a text box to the font size
I know how to set the font to automatically resize to the text box, but is there a way to automatically resize the text box to the font size? Very often I have the font size exactly how I want it and I have to adjust the text box so it's as tight to the text as possible. If there isn't an automatic way to do this, this feature should be included in the next version of Publisher. ...

Parse(?) data from text file
I have a large text file that has hundresds (or thousands) of compiled questionairres that I want to convert to a more usable format (excel?). Here is what it looks like: ======================== Name: Joe Jones Address: 123 main comment: varies from blank to 20+ lines may have muliple paragraphs others: 8 or 10 other fields =============================== next questionnaire ====================== A couple of details: the separator line of ====s vary in length, the individual questionnaires are not always identical. Some have a couple of extra 'fields'. I envision a separat...

how do I convert an imported number to text
I am downloading data from a computer and wish to convert the number to text in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine and each one represents a different problem or failure of a piece of machinery Have you tried Find and Replace (Ctrl+H) -- Jacob "Lyn" wrote: > I am downloading data from a computer and wish to convert the number to text > in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine > and each one represents a different problem or failure of a piece of machinery ...

I want the day of the week when I insert a date
Excel 2003 WindowsXP I am creating a spreadsheet and inserting many dates. I want to insert the date and have the day of the week of that particular date appear. Otherwise I would have to look up years worth of dates. Is there a way to do this? Thank you. Right-click on the cell with the date you wish converted to "Weekday" > Format Cells > NumberTab > Custom > and type dddd in the little window....> ok Vaya con Dios, Chuck, CABGx3 "HT" wrote: > Excel 2003 > WindowsXP > > I am creating a spreadsheet and inserting many dates. I want to ...

Publisher Text Box #2
I am looking for guidance on missing text from text boxes. I understand how overflow works, but this is a different problem. I am preparing a trifold pamphlet where it's important that my text fits into each third without overlapping the folds. I have one long text box filling each third. The only text box that displays all contents when printed is the center third. The first few letters of each line in the left third are curtailed at the left margin. The last few letters of each line in the right third are curtailed at the right margin. I have played around with the margins on bot...

IF Function with Dates
Hello, I hope someone can help me. I would like to create an IF function for dates in my worksheet. I have a Start Date column and End Date column. If the date in the Start Date and End Date falls within the Fiscal Year(06), then I want to display a 1, otherwise a 0(zero). A1=7/01/06 (Start Date); B1=6/30/10 (End Date) FY06 is from 7/1/2005 to 6/30/2006 What I have in C1 is =IF(AND(A1>=7/1/2005,B1<=6/30/2006),1,0) My result for FY06 is 0, but that's not correct because the End Date is not until 12/31/2010, so it falls within the FY06. I want this formula to...

How to combine text and the value in another cell?
Excel 2007 Lets say in A2 I have a calculated value of 2 in A1 I want it to say The total of XX = 2 This is what I tried: =CONCATENATE(The Total of XX =,A2) Gave me a "value" error what other approach should I try? tia dave Try this: ="The total of xx = "&A2 -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Dave" <dave@accessdatapros> wrote in message news:20C0AC3C-2CF3-49BC-8837-428F60A42692@microsof...

Autorun macro by date
This is a repost as my one this morning doesn't appear to have saved, so ap;ologies if I end up raising the same question twice. I have a macro called 'Update_Me'which I would like to run automatically on the first of each month (when excel is opened, obviously). How do I go about this? Thanks in advance Steve Try something like: Sub Workbook_Open() Dim dToday As Date dToday = Now If Day(dToday) = 1 Then 'rest of code here End If End Sub --- Place this in ThisWorkbook module. HTH Jason Atlanta, GA "Steve" wrote: > This is a repost as my one this morni...

How do I enter dates with one keystroke
I am new to excel. This may be the stupidest question of all time, but I would like to know how to assign, program, or whatever you call it in excel a date to a key so that when I am in a cell and want to enter that date all I have to do is use one keystroke. For example, can I somehow assign a date like 07/26/08 to the F10 key so that every time I press F10 the date 07/26/08 is entered into the cell where the cursor is? Thanks in advance for any help you can provide me. -- barefoot This may not be exactly what you're looking for, but to enter the current date in a cell click ...

Changing Mail Format to HTML/Plain Text Doesn't "Stick"
I am having trouble with about 30% of the people I send e-mail with attachments to. If I manually force plain text (usually HTML is not an option) by changing the Internet Format property on the e-mail address, the attachments always come through. However, the default property seems to always be to let Outlook decide the best format (which must be RTF and people can't receive). Via Options/Mail Format, I have "Compose in this message format" defaulted to HTML. In Internet Format, I have Outlook Rich Text Options set to "Convert to HTML format". I've tried "Co...

Why does this text automatically update?
I'm editing a newsletter used by former staff members created in Publisher 2003. (I'm using the same program.) There is a text box on each page in the same spot that says "Volume # Issue #." When I edit it on the first page it automatically changes on all the other pages. I don't think it is an object, embedded or linked or otherwise, because the "Edit Objects" option is greyed out. What is it, and how can I edit/replicate it? It's synchronized text. From Publisher's Help File: When you create a publication from a Publisher wizard or by using Publi...

Search box for text
I'm looking for a solution for an item search box for an inventory. I have a spreadsheet that I need to find "Name of product" and scroll it up to the bottom of my frozen pane. I've searched the discussions forum and tried several formulas, non have worked for me. In my frozen panes view, I'm looking to have a search box to type an item name in and have excel scroll it up to the bottom of the frozen pane. The item names are in column "D". Any takers????? Thanks, Allan Grates You are not going to be able to do this with formulas since formulas cann...

Plain Text #3
Hi, I recently upgraded Outlook from 2000 to 2003. It now appears I have a problem with message formats in my INBOX. Messages that have been sent to me in Plain Text cannot be read, and for each message I have to manually change the format to HTML before text shows up. No problem with old messages that were sent in HTML or RTF. I don't understand this. Who can help ? tks Maarten ...

Text field size not matching
The help file says that custom fields text1-30 can have up to 255 characters but when I go to add that field to my Task Sheet it will only allow 128 characters. Any info would be greatly appreciated. Hi madsmom, I can add/view approximately 251 characters in the field when added to the table. Did you press enter when typing? If so, it will truncate at the first return. I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project "madsmom" <madsmom@dis...

Count text cells if condition in row is true, over many rows.
Using Excel 2003 - 84 columns, up to 250 rows. By groups of 3 adjacent columns, I want to put (in merged cell at top of each group of 3) a formula showing total of cells with text, IF a separate cell in column CM in each row has a particular value. So, there will be 28 totals (84/3) in top row. If CM2="E", CM3="S", CM4="E", CM5="E", CM6="S", etc, and using condition "E", the formula in merged D1 will count all text cells in columns D,E,F of rows 2,4,5,etc. The formula in merged G1 will count all text cells in columns...