Change of recipient/sender display name
Environment :- Windows 2003 x64 with exchange 2007 (All in one role)
Outlook client :- 2003, 2007
We have created a list of mail contacts (which under GAL) in exchange
2007, these mail contacts are associates with external email address,
each of contact has a naming standard for display name, for example,
display name is HD Finance Manager, external email address is
I want to configure outlook client to show the display name according
to mail contacts whenever the email address is match to mail contacts
list (GAL), for example, an email sent from the email a...Payroll Batch Number
Is it possible to obtain the batch number of a transaction after it has been
posted? I have been asked to create a report for our payroll department that
lists the batch number in addition to the transaction detail that is
contained in UPR30300.
No, the batch number is not available for reporting.
Charles Allen, MVP
"Jeff Majchrzak" wrote:
> Is it possible to obtain the batch number of a transaction after it has been
> posted? I have been asked to create a report for our payroll department that
> lists the bat...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...Auto formatting features: How do I align page numbers in publicati
I've got a problem with my publication. I can't align even page numbers to
the left without automatic moving the odd numbers to the left as well? Can
someone help me?
> I've got a problem with my publication. I can't align even page numbers to
> the left without automatic moving the odd numbers to the left as well? Can
> someone help me?
You need to create a two-page master rather than a one-page master. What
version of Publisher are you running?
Ed Bennett - MVP Microsoft Publisher
...How to display Total Item Quantity on receipt and Status bar
I would like to print a total Quantity of items purchased on receipt and the
I found a way of displaying them but the problem is that we use tag along
items for alcohol tax . This tax differs based on alcohol content and size,
example a 6 pk of beer has $0.20 tax plus sales tax, a 750 Ml a bottle of
wine has $0.116 tax .
If i ring up a 6pk or beer this would show up as 2 lines(line one name and
price for beer , line two alcohol tax tag along item) on POS screen and the
Total items and total QTY count shows as 2 when in reality only 1 item was
This gets even more conf...Numbering Recurring Items #2
Is it possible to number recurring items such as tasks and appointments? I
have several recurring appointments for lectures, and would like to show
them as "Lecture 1" in week/occurence 01, "Lecture 2" in week/occurance 2,
"The journey of 1000 miles begins with a broken fan belt and a leaky tyre."
"Duct tape is like The Force. It has a light side and a dark side, and it
holds the universe together."
"If the facts don't fit the theory, change the facts." -Albert Einstein
&...Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back.
I have tried doing everything in cell format etc.. anyone have an idea? it is
very annoying and adding loads of work to my project.
> Even when I open a brand new file. I input a number (ie 5)
> and get 0.05 back. I have tried doing everything in cell
> format etc.. anyone have an idea? it is very annoying and
> adding loads of work to my project.
I want to change the way the date appears in the footer and header.
Currently the date is day/month/year. I want month/day/year.
setting the date to a particular format is easy in a cell.
How do I set the date format in the header and footer?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
jamessem, you could use a macro like this to do it
.LeftFooter = Format(Date, "mmmm dd, yyyy")
...Getting same number to appear over and again
Hi. I'm trying to change the E's I have entered in a column to 1's. However,
in lieu of changing them one by one, I would like to do them all in one fell
swoop. Any suggestions?
You could use find and replace.
Select all of your data. Goto Edit>Find
Find what:- E
Replace with:- 1
Do NOT multipost. See your answer in Excel group.
And do a google search for newsgroup etiquette!!
Do NOT multipost. See your answer in Excel group.
And do a google search for newsgroup etiquette!!
Do NOT multipost. See your answer in Excel ...Rounding actual results
I've got a grid that says:
Maths: 5 25
English: 7 25
And so on.
I'm wanting to work out how much time is devoted to learning in the whole
week. What I've got so far is:
Total learning time: =A1+A2...
all totals in
My current answer for hours is 18.
I'm stuck with what to do with the minutes column. so far, I've got an
A general query
Im serialising a person object with the following member variables
Private _forenames As String
Private _surname As String
Private _dob As Date
Private _marital_status As MaritalStatus
'Public Get and Set Properties here for each of the above
' I'll not detail them all to save space but Ill show attributes
<XmlElementAttribute(Elementname:="dob"...Repeat statements "x" number of times...
I have the following code at the end of a long macro:
ActiveCell.FormulaR1C1 = "=Sum(RC[-1]-RC[-2])"
ActiveCell.NumberFormat = "0.00"
ActiveCell.Font.Bold = True
.ColorIndex = 6
What I am doing is when the word "total" appears, it will go to the cell 4
columns to the right, and then do a formula and format the cell.
Question: How can I get this to repeat itself for eac...Displaying time from 00:00 to 0.00
I want to do the opposite to what I have seen on the forums and convert
time back to decimals ( I work on aspreadsheet but it has been
passworded so I can't crack it. :)
I want to be able to write
(van out) (Van back in)(Total Van time)
7.25 11.25 4.00
Can anyone help me please ( or a way to crack passwords):cool:
North for Short
North for Short's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22695
View this thread: http://www.excelforum.com/showthrea...sort special text/numbers in format with many dots
I need your help with sorting in Excel!
I have mani Text fields with numbers into it.
And it should sorted like this
How can I sort this like numbers? My problem is, that not all Numbers have
the same format as x.x.x.x! And I can't change this Text-Fields to Numbers,
because 10.6.1 looks the like 37052 :-(
With your data in column A, insert a blank column at B.
In B1 enter
=IF(ISNUMBER(FIND(".",A1)),LEFT(A1,FIND(".&q...How do I format cells to a specific number of digits?
I am trying to format a column so I can enter 5 digits only. It has between 5
and 7 digit numbers in it right now and I need to delete the remaining ones.
It is about 350 numbers, so it would be a lot of work to go into each cell
and delete the remaning numbers. Is therea way I can format the whole column
to allow 5 digits? The same happened with letters. I had codes in it that
consisted of numbers and letters and the client only wants the first two
letters to remain. How can it be formatted so only 2 characters are allowed
to keep me from having to enter each cell separately?
form...Vendor Address ID should always be stored with Voucher Number
The Vendor Address ID should be stored in more places in the PM tables. This
will make it easier to pull the correct address for reporting purposes.
You should also be able to click into the Address ID field from the Payables
Inquiry rather than having to go through the Vendor Inquiry. This will make
it easier to look up what invoice was sent to what address.
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...Number of selected shortcut files
Does anyone know of any function that can tell us number of shorcut files
selected by a user on Windows Explorer.
Based on my experience, there is no direct method. I suggest that you can
perform the following steps to implement this functionality:
1. Use FindWindow to get the handle to Windows Explorer.
2. Call EnumChildWindows() to find the handle to ListView in the Windows
3. Get CListCtrl from CListView.
4. Retrieve the selected listview items, and count the items whose type is
Please feel free to let me know if you have any problems or concerns.
Have a ni...can Excel randomly sort numbers
I would like to sort numbers in a random sequence. How can I do that in
Excel or any office application?
"gasmith" <email@example.com> wrote in message
> I would like to sort numbers in a random sequence. How can I do that in
> Excel or any office application?
Yes. Assuming that your numbers are in column A, insert =Random() in column
B. Drag this function downwads so that you have as many calls to Random as
you have numbers to sort randomly.
Select columns A and B
Select Tools|Sort and sor...Increase number of calendars which can be viewed in outlook
Does any one know how I can view 35 calenders at once side by side in outlook
rather than the stipulated 30?
...Help with summing numbers in cells that also contain text
I have a work schedule where the column heading is the employee's name and
the cells below indicate what the employee's status was for that date, as
col A col B
01/01/07 8.0 SIC
01/02/07 4.0 SIC
01/03/07 D (indicating worked the day)
01/04/07 8.0 VAC
TOTAL SIC Hrs: 12.0
I've tried extracting the numerical values into a hidden helper column "C"
using the following formula: =IF(RIGHT(B2,3)="SIC",LEFT(B2,3),"")
It extracts the correct value, how...again: number a list
I found a thread "number a list" (June 2nd.2006):
>I have an excel ss of book and video titles. I would like to make one
>the number corresponding to each title. Just a simple scheme like 1, 2, 3,
>4, 5, etc...
>How would I tell excel to put sequential numbers in a column?
The problem was solved easy.
But what can I do when I have empty rows? I entered free rows for better
looking print result, unfortunately BEFORE >fill>series.
Is there a formula, something like IF B1>0 fill A1?
Thanks for help!
Mike, have a look here and see...Masking Bank Acct Number on DD Earnings Statement
How can I mask the Bank Number and Bank Account Number to show only the last
four digits on the Direct Deposit Earnings Statement?
I have looked at the knowledge base article on masking the social security
number and it is close, but not every employee has the same bank account
number length. Some employees could have an account number length of 8 for
their account and others could have 12.
If you are a microsoft partner, You can also post your question in Dynamics
GP Partner forum that might help you receive suggestions from others also
http://social.m...Can I scan a table with numbers in it into Excel?
Most scanners come with software that allows you to read the data into
wordprocessors or spreadsheets.
I wouldn't be too optimistic about the reliability, though, if the tables
are not explicitly meant for character recognition.
Microsoft MVP - Excel
"lmc" <firstname.lastname@example.org> wrote in message
When I've done this, I just scanned into a *.txt file using the scanner's OCR
software, and then read that into Excel in the normal manner.
Simple tables w...Business Card Numbering
Is there any way I can get publisher to auto number
business cards on a single sheet from say 1 - 10, then 11 -
20, and so on?
There is full information here:
If you need any further assistance don't hesitate to post back here.
Yes, but not if you start with the Business Card wizard.
Here's a technique which will allow anyone to number any size document.
First, create a list of numbers in a format that Publisher can merge from.
Publisher can handle most database formats, including text lists, but the
easiest way is probabl...QS2000 Auto-Increment Customer account number problem
I have a customer that is running QS2000, version 3.01N, and has for
years had the option set in the INI file to auto-increment the account
number when adding a new customer. Suddenly, a few weeks ago, the
auto-increment stopped working and all the system will do now is try
to assign the last new number that it assigned (and yes, it is
assigned to a valid customer).
I can't find anywhere in the tables where a "last new number used" is
stored. I would appreciate any ideas on how to fix this so that it
will start assigning the correct numbers again. I have already tried
to repair ...