Search last 4 digits in an (account number)
I store bank accunt and credit card numbers in various Contact Notes. For
example, a credit card # as xxxxxxxxxxxx1234.
Outlook contact search would not find this contact if I enter the search for
Is there a way to do this in Outlook 2007?
PS - this search works fine in Outlook Mobile.
outlook searches from the beginning - so it will only work if you use
xxxxxxxxxxxx 1234. Other search tools (like google desktop) may find it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: htt...Calculating greatest number in a range
This is a little tricky to explain, but hopefully will make sense.
A series of data is produced that monitors concurrent users on a
system. This is returned every five minutes of every day.
This is on a work book which has a month for each tab.
Data typically comes in the following, simple form:
Wed Nov 26 10:50:01 GMT 2008 0
Wed Nov 26 10:55:00 GMT 2008 0
Wed Nov 26 11:00:00 GMT 2008 1
Wed Nov 26 11:05:00 GMT 2008 1
Wed Nov 26 11:10:00 GMT 2008 1
Wed Nov 26 11:15:00 GMT 2008 1
Wed Nov 26 11:20:00 GMT 2008 1
Essentially, I need a way of differentiating between indivi...Same operations on a variable number of rows
I am posting this to both the regular and the programming group
because I don't know if the solution requires programming. If not,
sorry and ignore this.
Anyway, here is my questions. I have a specific and then a more
general issues. I have a set of data that changes frequently. In
particular, the number of items change. What I want to do is get the
list of unique concatenations of the items. Now that part is easy. I
concatenate the cells. Copy as value. Then make a filter unique. But
that is lots of action on my part. I have to copy the concatenate
formula to a variable number of rows. I...Can I make the scroll bar show the row number?
My previous version showed the row number as I clicked on the scroll tab and
pulled it up or down, making for easy location of the line I'm looking for.
Excel 2003 does not show the line (row) number. Is there a way to turn on
this feature in this version?
This nice feature was not included with Excel 2002 either.
I think it was exchanged for seeing the pixel size when you drag to adjust a
column or change a row height. Yippee!
Gord Dibben Excel MVP
On Wed, 23 Mar 2005 15:47:04 -0800, "Marcia Duckworth" <Marcia
...How to response to the event of dynamically-created and indefinite-number control
I need to dynamically create controls according to the input of user, and reponse to user's operation on these control.
For example, when user input 10, I need to create 10 checkbox and reponse to the click event of these checkbox.
As far as I know, if the number of control is definite or determined, I can use ordinary message map to satisfy this requirement. But in my project, the number depends on the input of user, and I can not associate a ID with a event
I have tried to reponse to the WM_LBUTTONUP message in pretranslatemessage, but to my disgust, when user press the mouse button insi...Serial number notes
We would like to have Serial Number level notes to track particular issues
with that item/serial number such as warranty support issues, part
replacement and warranty registration.
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolut...Look for: Search In => Choose folders=> Search subfolders not working
When I search for an old email using Outlook's Look for: box and specify
which folders to search in via the "Choose folders=>Search subfolders"
checking a folder does not actually cause any subfolders to be checked.
Unless there is some other setting and/or option hidden away somewhere, the
"Search subfolders" check box is not working. I must manually check all the
desired subfolders. What am I doing wrong?
Santa Monica, CA USA
To email me, just pull 'my-leg.'
...Certain numbers =S
I have a form that is used to calculate a products price. One of the cells
is "S" foer stock and "NS" for non stock.
#'s 32, 56, 87, 45 and about 5 others are "S" . Abouit 10 sets of numbers
are "NS" It would help greatly if excel could fill in the cell with the
proper response by inputing the #'s in say cell a1. Hope I made this clear
If I interpret your requirement correctly, only you can know whether or not
something is in stock and insert the appropriate flag. If you then want to
use this flag in you price list you coul...Positive (+) Number....
If I type into my worksheet -120... it shows up as -120
However if I type +120... it shows up as 120.
How can I tell excel to show the plus sign in front of positive
Thank you all!
You need a custom format
Use the following as your custom format:
"Shhhh" <email@example.com> wrote in message
news:79399788-e5a6-4c7f-9706-8995f6ddd2eb@z9g2000yqi....converting 1.x database to 2.0 from DOS files
I saved the 1.x database on floppies. Now I need the
database again and need to upgrade it. How do I copy the
floppies with the 1.x database so that it will work with
access 2.0 in an XP pro environment?
...Searching for Newsgroups
I subscribe to a Usenet service for accessing various news groups.
After I download all the newsgroups from that server I can not find a way to
search for the newsgroups I have interest in.
When I put something like "RV" in the search box on the top right corner, it
searches all of my Emails rather than just the list of groups that had "RV"
in the title.
Help tells me that there is a " Display newsgroups containing" box but for
the life of me I can't find it.
Any thoughts out there?
I am running Entourage 12.2.3
Click the bar in th...Creating more than 1 line in a cell
Is there any way to create more than one line in a cell?
You cannot use the RETURN or TAB keys since they take you
to another cell.
I tried using three cells and then merging into one, but
then it only keeps the information form the uppermost cell
and then deletes the data in the other two cells.
Text-wrapping doesn't work because if the word(s) on the
top line is long enough, then I have to add several spaces
before it will be forced to go down to a second line.
I've tried Excel Help, but it goes to autoformat and none
of the formats are the ones that I want.
Thank...Search & replace in formulae
Is it possible to do a search and replace which includes
the cell formula contents ? I have a workbook that has
cells which link to the contents of a cell in another
workbook and I'd like to know if the naming has to remain
constant or if I can replace a part of the name
periodically. ie each year.
"Iain Rhodes" <firstname.lastname@example.org> wrote in message
> Is it possible to do a search and replace which includes
> the cell formula contents ? I have a workbook that has
> cells which link to the contents of a cel...Search engine optimization
My question today regarding this issue is: I have noticed some sites have
the following on their sites "Source".
meta name= "robots" content="Index, follow"
meta name= "revisit-after" content="15 days" or (30 days)
What does this function accomplish as far as search engines go? and will it
really imporve your results ( rankings) Like for instance "robots" "index,
all" what is the difference between this and saying "robots" "index, follow"
I'm a bit confused about this. Can someone ...Can I search identical fields from multiple tables?
I have a database to log details about staff in my school. I have a tables
for staff details, courses, absence, educational visits etc.
In each table I have a date field to show when the member of staff is not
I want to produce a query to search all tables by entering a date - e.g. to
bring back all results for staff who are not in school on a certiain day
because they are either ill, on a course or on an educational visit. The
query will work by entering a date once - it will then search all the other
tables and bring back the results.
Is this possible? Do I restructure?
...How To Import Blank Fields into Picklist Fields
I'm importing Contacts using the simple method (tools-
Everything is going well except for little thing: I can't
seem to import blank data values as blanks. If I map the
blank data value to "Default Value", then "Default Value"
is literally imported (without the quotes).
Do I need to use the Data Migration Framework to get this
functionality? I don't want to go there, because I'm 96%
completed doing it the simple way.
Had the same problem
A simple workaround that worked...Office Test Drive re-installs over Office 10.1.5
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="US-ASCII"
Hi . . . this happened in reverse order from any of the other Test Drive /
full install postings I've found . . . In attempting to restore some
Apple-installed software that was corrupted in a hard drive crash on my 12"
Powerbook G4 (867mhz, os10.2.8), Office v.X Test Drive was re-installed.
Although all of my user data is still intact,...count the occurence of number in a column
may i ask: how do i count the occurence of a number in a column? an example:
occurence of 1 = 4
occurence of 3 = 1
occurence of 4 = 1
occurence of 5 = 2
occurence of 8 = 1
what would be the formula for that in excel, please? i have no clue at all.
i tried google and it came up with something but i could not really find the
answer to my question.
"Laura" <email@example.com> schrieb im Newsbeitrag
> may i ask: how do ...What does outlook search when you search Contacts ?
When you do a search in oulook for contacts, what is the criteria that
outlook searches? Or I guess how does outlook search? Why is it not
consistant? The reason I am asking is that we have our customers
contacts in public folders. In our customers we have 6 contacts for XYZ
Foods. If you search in outlook for just "XYZ" it only comes back with
4 of the six. If you do a search for "XYZ Foods" it returns with all 6.
And if you just entered "Foods" no contacts were found. And we actually
have a few companies in our contacts who's names are a two part name
ending...Templates are all blanks ?
Operating System: Mac OS X 10.5 (Leopard)
When I went to open a booklet this aternoon, all I got was a set of blank pages. NOT the thing I wanted to see after 3 weeks of work, and a due date of Friday. <br>
All of my other documents created with the Project Manager seem to be the same - all empty pages. <br>
It was working fine a week ago. <br><br> Trying to create a new document (catalog, newsletter, etc), I get the same thing. I can see the styles in the Project Manager, but none of them take - it just produces blank pages, no for...I am having trouble keeping numbers formatted in a Pivot Table
I have a pivot table that won't stay formatted. The data is formatted as
currency in the worksheet that the Pivot Table is drawing off of. It shows up
as a general number in the Pivot. I've tried formatting it in the Pivot but
it doesn't stay when I refresh the data. "Preserve formatting" is checked on
the Pivot table, so it SHOULD be preserving any formatting I apply to the
pivot table, but that doesn't seem to be happening. I know I could record a
macro to format this, but it is happening on multiple Pivot tables in the
same workbook and that would be a pain ...Maximum number of data points
I'm wondering if there are any downloads to increase the maximum number of
data points for Scatter plots in Excel. I'm restricted by the 32000 point
"Zero" <Zero@discussions.microsoft.com> schrieb im Newsbeitrag
> I'm wondering if there are any downloads to increase the maximum
> data points for Scatter plots in Excel. I'm restricted by the 32000
How would i search a range of a whole column instead of specific cells
Message posted from http://www.ExcelForum.com/
are a few ways.
"Zygoid <" wrote:
> How would i search a range of a whole column instead of specific cells
> like .Range("a1:a300")?
> Message posted from http://www.ExcelForum.com/
I was trying .Column(1)
i see i neede an "s" in there
Thanks a...Sorting numbers acts like text sort
We have a worksheet (Excel 2000) that was e-mailed to us.
When we open it, it says there are macros, which there
aren't. No matter if we say "Disable" or "Enable" macros,
all cells are formatted to "General", and when sorting,
the numbers 10000, 7102, 1169 sort as: 10000, 1169, 7102.
We can try to format as number, but to no avail. Sorting
still isn't right. Have seen this many times before, but
don't know how to resolve. Can you help? Thanks.
Never mind. Sorry to waste your time. Saw two suggestions
below on this page. Missed them the first ...Side-by-side installation of Visio 2003 and VEA that came with VS 1.0 Enterprise
Please let me know if installation of both Visio 2003 and VEA that came with
VS 1.0 Enterprise on the same machine is officially supported.
I can't speak for M$, but they respond that it does work (although a pain in
the butt to reboot when you need to move from one to the other, also since
the VEA version is really v2002 understand the VEA version may not read the
"TomTom" <firstname.lastname@example.org> wrote in message
> Please let me know if installation of both Visio 2003 and VEA that came