change date format from dd/mm/yyyy to mm/yyyy
I have a column with dates in dd/mm/yyyy . I want to get rid of the dd.
although converting the date format does the job.. but the dd/mm/yyyy value
still remains on the formula bar. this then makes pivot table analysis
difficult as I want to analyse by month.
Add a column for the month =MONTH(A1) and copy down, and include that in the
pivot. Maybe add a year and day column as well.
(remove nothere from the email address if mailing direct)
"flow23" <firstname.lastname@example.org> wrote in message
news:8F878380-3053-4E29-93D5-538BA9B9EFB3@micros...Customizing Activities\History LIst
Is there a way to add a date to Activities' History
list? It would be nice to know when each activity
Troy, no way currently, although Microsoft has mentioned it might be an
option in version 2.0 (nothing is guaranteed!)
A few ISVs have custom products that do it...
"Troy" <email@example.com> wrote in message
> Is there a way to add a date to Activities' History
> list? It would be nice to know when each activity
>...Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will
be numbered in "level 1" and have indented bullets in "level 2."
For such a list is it better to define a multi-level list style and
linked paragraph styles?
Or use one's already defined numbered list and use one of the Word's
pre-defined bullet lists when needed for the second level?
As part of this question, is is preferable not to have a style "nested"
within another style or doesn't it matter?
I'm not sure why yo...Distribution List Changes
I have a mail enabled distribution list with four users. Only those users
plus the Administrator have rights on this group.
Yet a seperate user is able to add / edit or remove users to this group even
though they do not belong to this group. The user does not even have admin
rights and is able to make changes.
Let me know of any options I can try.
> Hi All,
> I have a mail enabled distribution list with four users. Only those
> users plus the Administrator have rights on this group.
> Yet a seperate user is able to add / edit or remov...windows mail
I cannot receive email. last email I received was 7/16/10.
You haven't given us much to go on.
Do you get an error message when you try to receive? If so,
right-click on your error message, copy, then paste it into a
reply here. We can't do much troubleshooting without the
complete error message.
If no error message, are new messages accumulating in your
webmail? What happens when you send an email to yourself?
Gary VanderMolen, Microsoft MVP (Mail)
"tstaz" wrote in message news:FEC180FB-2C15-4AD9-A6B4-...Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I
have a drop down list like this
ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible
for me to see only all the check box that was checked or vice
versa...??? How to make a total below the checkbox i mean when someone
check the check box, a total number appear below the last check box
[image: http://www.g...Data Sort with header row
How can I set the default so that the "with header row"
indicator is flagged as opposed to the "without header
Don't think you can. You can help Excel make a guess by
making the formatting of the header row differ from the
data below it, by making the header Text, and Bold; which
helps but is far from being reliable.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Ian" <ian@ckf....Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some
do not. All sound came from the same folder. Also, when playing the slides
while in PPPresentation, swome have sound and some do not despite all being
indicated on custom annimation lisy and all startin "after previous."
Often when one sound plays but another doesn't, it's an issue of the length
of the file path. What's the file path to your music? Is it really long? If
so, the longer-named songs might just be hitting the length limit.
Echo [MS PPT MVP] http://www.ec...Outlook Mail #6
Using outlook to download email from Comcast. Have XP and
using Norton for virsus and firewall. Downloading of
message is rejected and received this error message
1x800ccc13 sometimes messages are downloaded other times
they are not - server blames Norton, Norton blames the
Try unchecking the email virus scanning and see if it works then.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.gr...IMAP Rule prevents mail deletion
Operating System: Mac OS X 10.5 (Leopard)
Email Client: imap
The user has two email addresses. We setup a rule to put email sent to a particular email address into another folder for easy sorting. This is working fine. <br><br>However, when trying to delete an email from the folder that receives these moved emails, the deleted item shows up for a split-second in the 'deleted items' folder, then reappears in the filtered folder. <br><br>When the rule is disabled, the email can be deleted as normal. <br><br>The rul...how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted
me is still on this list (I don't think she blocked me), but when I
check who deleted me on blockstatus.com, he shows up.
could it be it's not updated? which of the two would be more reliable?
Do not use these websites, they will steal your identity and sell it. You should change
your password immediately.
That said, in general, the "who has..." list within Messenger is accurate. There have been
instances over the last six-months or so where the list (and m...Disable Auto date
How to disable Auto date (The balue that gets updated to
today's date ). I want to preserve the last opened date on
How do you put the date there?
If you type it, you could type the date (or hit the ctrl-semicolon shortcut
HItesh Zinzuwadia wrote:
> How to disable Auto date (The balue that gets updated to
> today's date ). I want to preserve the last opened date on
> the sheet.
> Thank you.
...Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those
with a common extension i.e. all those who have email addresses @hotmail. I
am using Outlook 2007
Can you do a search or advanced search which will show the contact you want
to delete? You should be able to highlight & delete them from the results.
"GrahamC" <GrahamC@discussions.microsoft.com> wrote in message
> I have all my contacts in the Contacts List and I want to delete all those
> with a common extension i.e. all t...deleting mail on opening
outlook is deleting messages on opening and not sending
to the deleted items folder how to fix ??? please and or
how to restore to default settings ?? ty srirlee
...Script to list access right
I am trying to find any script which would generate list of login users with
certain access level (select, write etc.) at one particular database.
Is there something like that?
...Inconsistent behaviour of attributes accessed through structured r
I have a table that represents information in an outline structure.
The table has two columns, "Level" and "Requirement" that look like this-
1 Top Level
2 Next Level
2 Next Level again
3 Further sublevel
2 Back to Level 2
Now, what I want to two functions that will-
1) Set the indents of the "Requirements" column based on the level numbers,
2) Se the Level numbers based on the indents of the Requirements column.
Sounds easy, And one way it is!
Can anyo...a list of lists
currently i use CArray to keep track of a list of objects, but I don't
know MFC classes well enough to keep track of a list of lists. I'd
appreciate some suggestions
"wanwan" <firstname.lastname@example.org> ha scritto nel messaggio
> currently i use CArray to keep track of a list of objects, but I don't
> know MFC classes well enough to keep track of a list of lists. I'd
> appreciate some suggestions
You might want to embedd your list based on CArray into a class (e.g.
CListOfSomething), and then ...Smart List export to Excel #2
We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List
export to Excel, we keep getting an "Exception_Class_Object_Exception" that
references varying object errors, such as 'Cells' or 'Value'; the object
errors will change each time we try an export. As a workaround, I've found
that closing Excel before doing the export allows the export to complete
successfully. However, that solution isn't acceptable, as our Dynamics users
would like to be able to work in Excel, doing other tasks, while the export
is processing. Does anyone...Having Windows Live Mail also accessible on net
I use Windows Live Mail as my email pop3 account for mail.
My question is why, when I go to another computer, use the net, go to WLM,
use the same name and password, do I not find the same emails, saved to be
able to access them while away from home?
2nd Question: What is the address to access the Microsoft forums that are
replacing their newsgroup service?
That feature is known as message syncing, i.e., keeping the messages for
that account mirrored the same on all computers accessing that mail
account. The common POP3 mail protocol does no syncing,
To get true syncing you...List of different values in data area
Hi excel specialists,
How Can I automatically get the list of different values from the dat
area and to find out their frequence?
INDIVIDUALLY MEASURED VALUES:
3,5 4 3,5 4 3 3,5 4 4 3
3,5 4 3 3,5 3 3 3,5 4 4
Thanks for your help in advance. Balcovja
balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623
View this thread: http://www.excelforum.com/showthread.php?threadid=39572
Take a look at FREQUENCY in Hep
(remove nothere from the email address if m...Make table query with calculated date fields
I have a make table query that calculates requirement dates based on a
[StartDate]. All of the fields (80 of them) are set as Short Date in
properties. But when the table is created all of the fields are text. I would
like to avoid using the FORMAT command in the query and change the field
properties of the table manually. Does anyone have a suggestion? Thank you in
advance for your help.
Share the SQL view of you make table query.
Microsoft Access MVP
> I have a make table query that calculates requirement dates based on a
> [StartDat...Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway
to have exchange add the GAL to the outlook contacts on the workstation, so
that when they sync up, they will retrieve the Global Address List?
Flip <email@example.com> typed:
> We use Ipaqs throughout the company, and I was wondering if there is
> anyway to have exchange add the GAL to the outlook contacts on the
> workstation, so that when they sync up, they will retrieve the Global
> Address List?
No (and this wouldn't really be an ...Fields in items list-- add/delete
I am using RMS version 1.2. In Stores Operations Manager it displays list
of items when click on Database-->Items. It displays only five columns.
Now i need to add / delete some fields in this list.
Is it possible to add or delete the fields? if yes how can i add the fields?
Thanks in advance,
On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra"
>Is it possible to add or delete the fields? if yes how can i add the fields?
I don't think so
I have an in-home netork. How can I e-mail from one
computer to the other without using the internet?
On Wed, 7 Jan 2004 19:20:15 -0800, "Tommy"
>I have an in-home netork. How can I e-mail from one
>computer to the other without using the internet?
So you're thinking that you should be able to use an e-mail program to
send to an address that does not have an Internet domain name?
On Thu, 08 Jan 2004 03:48:39 GMT, J C <firstname.lastname@example.org> wrote:
>On Wed, 7 Jan 2004 19:20:15 -0800, "Tommy"
&g...remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has
about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
in the big list as well. How do I extract those 6,000 entries from the larger
list? My expected result is a mailing list with 10,000 names.
Chip Pearson has some techniques at:
Howie J. wrote:
> I have two mail lists on excel. The first has 16,000 names, the second has
> about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
> in the big list as well. How do ...