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...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
>...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...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...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...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...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.
...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...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?
...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...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" <email@example.com> 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 ...week numbers
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...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
e...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...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 <firstname.lastname@example.org> 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" <email@example.com> wrote in message
> Dear Mary Sauer:...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
...Mac 98 Word page numbers
The page number command has disappeared from insert command. How to reinstall it?
...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 ...format of numbers in a downloaed file
I have a peculiar (atleast to me) problem,. I get some bills account from my
consultant. This is not in a webpage nor as an email message nor as an
attachment to an email message. I get these bills in the special software
which he has introduced in my computer. But when I < selectall> the entries
in the file and copy to an excel spreadsheet it serves the prupose mostly.
But some numbers are in a strange format neither as numbers, nor as text but
in some format such that I am not able to do calclations on these
I know how to convert a number in text format into num...To-do list
In Outlook 2007, I can't find a way to show a short summary of my e-mail
inbox on my Calendar page, similar to the way Outlook shows a To-do list of
calendar items on my Mail page.
It would save me a lot of switching back and forth.
If there is a way, please tell me.
If not, maybe you could consider adding it to the next version of Outlook.
Otherwise, I love the program.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the mes...exception list
where can I find the exception list for intelligent message filtering?
Global Settings in ESM
"jlconley" <firstname.lastname@example.org> wrote in message
> where can I find the exception list for intelligent message filtering?
Not sure what you mean - there's no exception list as such.
You can insert IP addresses of known/trusted hosts (from customers/partners
and such.. ) in Connection Filtering's Global Accept/Deny lists and these
will bypass all other filters. Will need to enable Connect...Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. Or, if
possible, the user could just select the icon (instead of selecting text).
Is this possible?
Use Data Validation for the list. Type in Red, Yellow, Green as the list.
This give the user the list to select from.
Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
If this helps, please remember to click yes.