Import records w/ date fails
Does anyone know the correct format for date fields during
import? I'm attempting to import a file into contacts and
leads that have date fields, but I keep getting an error
and the records will not import. I've tried variations of
date formats like:
Any help would be most appreciated... I know I'm missing
Thanks in advance!!
I just figured it out. Dates have to be imported as YYYY-
>Does anyone know the correct format for date fields
>import? I'm...Animated GIF as wallpaper question
Is it possible to use an aniamted GIF as wallpaper on an XP system and
if so how do set it up?
I tryed selecting an animated GIF as wallpaper but XP said it could
not find something about an aciv desktop something.
One way is to use the Active Desktop. Control Panel > Display Properties >
Desktop tab > Customize Desktop button > Web tab and then click the New
button to select the gif file.
"kraut" <NewsGroupsPlease@NewsGroupsPlease.org> wrote in message
: Is it possible to use an ...Bar Chart Question Multiple Elements
Greetings excel people,
I have the following data below and I want to create a bar chart fo
total # of yes answers, and the total # of no answers for eac
category, for the current location. In addition, I need each tota
displayed to its corresponding bar.
How do I do this? Thanks for your needed help
Location Answer Q1 Q2 Q3 Q4
TB YES 12 23 23 2
TB NO 34 33 4
Message sent via www.excelforums.com
Put the data in columns in Excel like you posted below.
Highlight all the data (should be 6 columns and 3 rows)
and either click the Chart icon or click on Insert in the
I have a generic account which 3 people have access to
that. (I have added that account for them through advance
option in Services). however when they reply any email
from that account, the sent email will store in their
mailbox not on "sent items" in generic mailbox.
Is there anyway to keep those replis in generic
email "sent Items"?
Check out "unisent" ?? from www.ivasoft.biz
> I have a generic account which 3 people have access to
> that. (I have added that account for them through advance
> option in Services). however w...Day part of date
In B2 I have 27/11/08
In A2 I am trying to extract the day as ddd (Thu in this case)
If I use =Day(B2) in A2 with the cell formatted as ddd I get Fri.
I tested in another cell with =B2 formatted as ddd - dd mmm yyyy and I
correctly get Thu - 27 Nov 2008. Why does the cell A2 result fail, and is
there an easy way to do this?
Since you've already formatted A2 to "ddd", use
as the formula in A2.
Please keep all correspondence within the Group, so all may benefit!
===================================...Mail Merge and conditional formatting Word 2007
Need some Help..
My disconnects mainly
pertain to the use of e-mail merge in Word 2007. The data file I need
to use currently resides in an Excel spreadsheet because of the need
for several formulas. I can merge most of the data successfully with
the exception of:
=B7 Multiple rows of data per e-mail.
=B7 Cannot edit individual e-mails prior to completing/sending
the merge. (This is possible with a regular letter merge, but cannot
do this with e-mail merge)
=B7 Merging conditional formatting icons (if this is even
possible, I don't know) We're using OnMa...Excel
Is it possible to convert day of year to date format (assuming all date
e.g. 001 to 01 January 2002
or 366 to 31 December 200
Message posted from http://www.ExcelForum.com
> Is it possible to convert day of year to date format (assuming all
> dates are 2004)
> e.g. 001 to 01 January 2002
> or 366 to 31 December 2004
> Message posted from http://www.ExcelForum.com/
Thanks Frank this works perfectl
Message posted from http://www.ExcelForum.com
...RE: Question about numbers lined up against dates
This works below for 1 year BUT when I get more than 1 year it still just
looking at months.
ow can I change toe formula to look at years as well as months.
A= #ID, B= Price, c = DueDAte, D= Qty, E= Numb Due
formula in e2:
Copy the formula down, and multiply the result by the price in column f.
> Hey all,
> Lets see if I can explain this one.....
> In Column "A" I have a series pf part number- IE 123, 442, ER45 and a
&g...Format all comments made now and in future to be size 14
How do you format all comments made, in all workbooks, to be 14 Times New
Roman? How do you do it before, not after...
Check out the below by Debra Dalgleish
If this post helps click Yes
> How do you format all comments made, in all workbooks, to be 14 Times New
> Roman? How do you do it before, not after...
...Chart Question #3
is it possible to create a chart, skipping columns or rows
I need to creat a chart using data from every other column and another
using data from about every 5th row
Any help appreciated
I'm open to correction on this, but I believe the best way to do this
(assuming you don't want to delete the in between data, and resort the
columns somehow) would be to create a macro that copies the data you want
into the right format (probably on another sheet) and make the chart from
Something along the lines of:
dim NewSheet as worksheet
dim OldSheet as w...Pivot Table border formatting and pivot chart formatting
I've haven't been able to eliminate the border formatting in a pivot
table. Every time I change the page selection it defaults back to
having borders. Does anyone know how to correct this?
I've also been having the same problem with pivot charts. When I
increase the width of a line in a chart and change the page selection
it defaults back to the previous format.
...Date/time range based calculations
I have a column of values associated with unique dates/times. I need to be
able to perform different calculations on the column of values based on
whether or not their associated unique dates/times are between a set of
date/time ranges (upper and lower limits).
What function should I be using to calculate column C based on the date/time
Column A Column B
Row 1 Start Time 03/01/2005 00:29:59
Row 2 End Time 03/01/2005 00:59:59
Row 4 DATE/TIME VALUE ...Outlook 2007 question
I installed outlook 2007 and now I try to customise it but I notice that the
Tools/Opions and Tools/Customize menus are disabled. Why and how to enable
I notice now that the problem is more severe. I cannot reply to messages,
save is not working. It seems that most of the functionality is disabled. I
can receive emails but cannot answer them.
Any clue? this is very bothering.
> I installed outlook 2007 and now I try to customise it but I notice that the
> Tools/Opions and Tools/Customize menus are disabled. Why and how to enable
> t...Place Cards using Business Card Format
Do you use the label size or business size category to prepare place
cards. After the design is completed, I want to retain the design but
be able to print 10 cards to a sheet and then be able to change
information in each place card, i.e. name, table number, etc.
You can design your cards then do a mail merge for the information if you put
the information into a data base or a Publisher list. What version Publisher are
Mail and catalog merge
Mary Sauer MSFT MVP
Doing some research on email archiving on Exchange Servers.
Anyone has an idea whether Exchange 5.5 had some sort of email archiving
functionality? Maybe through a SP?
Nicholas Aquilina <firstname.lastname@example.org> typed:
> Doing some research on email archiving on Exchange Servers.
> Anyone has an idea whether Exchange 5.5 had some sort of email
> archiving functionality? Maybe through a SP?
No - E2k/2k3 have "message journaling" that can send a ...Current month question
My data appears as such:
It must stay in this format.
The information I need is how many referrals were made
only for the month of July using this information.
Any ideas on how I might accomplish this?
where A2:A27 contains your dates
"Brandy" <email@example.com> wrote in message
news:7e2f01c4771f$8c7e1060$a50128...Security Settings in P2007 server
which security settings allow a user the ability to create an Issue or risk
for a project.
I have created a new group, catagory and template and everything works
except that they cannot create a new risk or issue on any of the projects
they have access to.
Can you tell us which of the SharePoint Security groups the users are
showing up under? My guess is they are showing up under Readers ...
- Web Administrators (Microsoft Office Project Server) DESCRIPTION: Users
who have Manage Windows SharePoint Services permission in Microsoft Office
P...GP10 Security Task Id Question
When building a task id you must select the Product, Type & Series.
Then in the bottom part of the scrollable area you select "operations"
to be included into the task. However, what is meaning of the
operations that are NOT checked? Are these operations not available
to any user in the system?
Users that have only this task in their role will have access only the the
checked operations, unchecked operations will be unavailable for those users.
But if the user was a member of other roles or tasks that have shared
operations checked, then the system will gain user...Setting the window class and name in a CRichEdit derived class
I'm trying to set the window class and name for automated testing on a
CRichEditView derived class. Unfortunately the name appears in the richedit
control as text and the name is not set. This technique worked on a CView
derived class. Can anybody help?
BOOL CLogView::PreCreateWindow(CREATESTRUCT& cs)
// Call base class PreCreateWindow to get the cs.lpszClass filled
// in with the MFC default class name
if( !CRichEditView::PreCreateWindow(cs) )
// Register the window class if a new one is defined.
...Column Chart Conditional Formatting
I have a column chart that compares 2 y values against a common x value. I
want to compare the second y value to the first, if it is greater then make
that bar green, if less then red, if same grey. Any ideas on how to go about
You'll need to do this by manipulating the actual data.
Setup 3 dummy series, first with a static value of 10. On the chart, format
these green, red, and grey respectively. Now, go back and change the static
values to formulas similar to this:
If ...Set all folders to AutoArchive
All the Outlook folders on my system are set to "Do not
archive items in this folder". Since I have hundreds of
folders it is a tedious process going to each folder and
changing the Properties|AutoArchive setting to "Archive
items in this folder using the default settings". Is
there a way to set all the folders to "Archive items in
this folder using the default settings" without having to
do each one separately?
Also, is there a way to set up Outlook so all new folders
are created with the AutoArchive set to "Archive items in
this folder using the d...Writing to a text file formatted as XML
I have a text file that looks like this:
<add key="db_server" value="someserver" />
<add key="db_database" value="somedatabase" />
Now, I want to check if value for db_server is empty and if it is, I want to
write the value. I am trying to use XmlTextWriter and XmlTextReader but being
new to XML processing I don't know exactly how to do it.
Can anyone help please?
The easiest way would be to load the document in Xml...Broadcase a setting change event?
I'm trying to change the editor type programatically by changing the
following registry value.
Outlook doesnt pick up on the change until I restart outlook.
Is there any message I can send so that outlook will refresh it's settings
and re-read this setting?
Outlook only reads many settings when it starts up. Blocked Level 1
attachments are just another example.
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Rem...Event Error Question
Can anyone tell me what the foioloing event eree is and if there is a way to
Event filter with query "SELECT * FROM __InstanceModificationEvent WITHIN 60
WHERE TargetInstance ISA "Win32_Processor" AND TargetInstance.LoadPercentage
> 99" could not be reactivated in namespace "//./root/CIMV2" because of
error 0x80041003. Events cannot be delivered through this filter until the
problem is corrected.
I google the event adn got several different opinions, one being caused by
...Setting up Message rules
I have read a few other post about setting up message rules, but I still
can't get my messages to go into the folders I have set up. Here is what I
have done. In message rules I have selected the Where the from line Contains
-email-. Move it to -set- folder. I then go to apply now. I change
"Storage Folders" to "Inbox" and then select Apply Now. Am I doing something
wrong? This is for my work emails. I receive lots of emails from a couple
different email address, and they are all POP3.
Any help to get my folders set up would be great!! THANKS!!