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" <firstname.lastname@example.org> wrote in message
> Is there a way to add a date to Activities' History
> list? It would be nice to know when each activity
>...Using TEXT and &TEXT
I'm familiar with the TEXT function, but sometimes a number will display
incorrectly when I format numbers to display with a comma if 4 digits or
more. For example, TEXT(F1,"0,0") will display 10 thru 999 correctly and
displays 1000 correctly as 1,000, but displays 1 thru 9 as 01, 02, etc.
Also wondering how to format part of a TEXT formula to underline, and bold
or color selected words.
Maybe you want:
If this doesn't help, maybe you could post the values and what you want to see
for a few exa...splitting a single cell
Is it possible to split a single cell in Excel 2003?
See your other post.
"BK" <email@example.com> wrote in message
> Is it possible to split a single cell in Excel 2003?
...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...how to prevent blank cell copied when combining cells?
I've tried to combine data from few cells using "CONCATENATE" function. But,
when a cell is blank, a blank appears in the result. How to prevent this
please give sample to understand better
"Vicneswari Murugan" wrote:
> I've tried to combine data from few cells using "CONCATENATE" function. But,
> when a cell is blank, a blank appears in the result. How to prevent this
=if(a1="","",a1&" ")&if(b1="","",b1&" ")&c1
It kind of sounds like you were separ...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...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...#VALUE! error adding cells
I am trying to add a row of numbers contained in every other cell. This
worked fine and I was able to copy the formula from one cell to the other.
On the final cell, instead of adding the numbers, I am getting the message
#VALUE!. I cannot figure out how to correct this problem.
Check to see if you have a text value in one of the referenced cells - either
actual text or a number that looks like text
"Frustrated computer user" wrote:
> I am trying to add a row of numbers contained in every other cell. This
> worked fine and I was able to copy the formula from one ce...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...Continue Numbering #2
I'm wondering if the "Continue numbering" option is in Publisher as it is in
I start creating a numbered list. After the second item, I need to insert a
few bullets. I then want to go back to the numbered list. Word has a smart
tag, asking if you want to continue numbering. Is there a similar feature in
Publisher? Right now, I have to go to Format, Bullets & Numbering and change
the start number every time this happens.
...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...Split text and number
Cell A1 = New England 30, Oakland 20.
Is it possible to have the following:
cell B1 = New England
cell C1 = 30
cell D1 = Oakland
cell E1 = 20
Cells A2-A16 are similar but the team name and number changes and the team
names are all different lengths.
If that won't work I could use text to columns and split it at the , so cell
A1 = New England 30 and cell B1 = Oakland 20. But I would still want the
team name and score to be separated. Using the above method would save me
from having to use the text to columns command.
If you use the text to column, you could then use =r...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...How to line up the last cell in each row?
I have some data for which I am only interested in the final column from
each row. The problem is that each row is a different length, so that row 1
may be 10 columns wide, row 2 15 columns, etc. How can I get the last
element from each row to line up in the same column so that I can sort, sum,
Here is one solution:
Insert a new column at A1 so you now have shifted all of your data to
the right. Assuming that Row 1 has headers your first data record will
be in row 2.
Type this formula into A2
Drag copy down to the end of your data.
Column ...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?
...macro to check if cells have values in them...then
Hi - I am looking for a macro that will check 2 things....then do something.
The first is if a range of cell values in are blank. lets say
Next is if a particular cell contains a given value ,
Sheets("sheet1").Range("E5") should equal "Year 1" if true.
If both these are true then I want the macro to copy a range of cells from
Sheets("Sheet2").Range("H6:H48") to Sheets("Sheet1").Range("D6:D48").
I tried to use IsEmpty but it seems to return a "False" if a...Truncating and rounding off numbers in VBA
Two simple questions that hopefully have simple solutions to them.
1) I want to truncate a number (34.6) so the end result only shows
34. I cannot find the function in VBA and its help service is of no
help? IS there one and if so what is it?
2) Also, is there a function for rounding off as well. I tried to set
the decmals property for an unbound textbox control to 1 but it has no
effect on the result numbers that come out (eg. 24.3245 instead of
24.3). Why is that and how can I solve this? I was thinking I could
use a roundoff function in VBA but can't find what it is or if it
In MS CRM you have week numbers which aren't equal to the ones we use in the
Netherlands. CRM says that 1 januari is week 1, but that isn't correct for
us. For us is the first week of the year where we have 4 days in januari.
How could I change this? Microsoft Outlook does it correct.
thanks in advance,
We had the same problem and found the following solution!
Make a backup of the [CRM-Directory]\_controls\datetime\date.js in and then
open it and replace the getWeekNumber function
with the following code:
function getWeekNumber( oDate )
var oSiebterJanuar = new...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...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...Text block query
I wish to create a block of several lines of text inside a border on a
What terms do I look for to describe this operation?
Just wasted an hour looking in vain.
I know I will kick myself when someone points me in the right direction.
Brian Tozer wrote:
> I wish to create a block of several lines of text inside a border on a
> What terms do I look for to describe this operation?
> Just wasted an hour looking in vain.
> I know I will kick myself when someone points me in the right
Cancel panic. Problem solved.
As usua...range specified by the value in another cell
I have the following problem:
I have let say 100 numbers in column A, and a number
n<100 in cell B1. I want to have the sum of the first
n numbers in column A, so I would need to specifiy the range
A1:An, but I need this independently of the actual value of n.
I have tried A1:A(B1) with but it doesn't work.
So has somebody any idea
Message posted from http://www.ExcelForum.com
2 ways for it
1. Use the formula
2. Create a named range
The formula will be
(When s...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 ...Removing Page Number from Final Page- Publisher 2002
Dear Mary Sauer:
I used the header function to page number my newsletter. I got rid of the
page number from the first page. How do I eliminate it from the back (last)
page. Iused the text box tip to do the former. Thanks Barry
Create a rectangle, fill with white, no line. Cover the page number.
Mary Sauer MSFT MVP
"Barry" <firstname.lastname@example.org> wrote in message
> Dear Mary Sauer:...