name of web service address
"glenn nehh" <glenn firstname.lastname@example.org> wrote in message
I shall name it... Bob.
In all seriousness, huh?
...How do I change my text direction to vertical on EXcell?
How do I change my text direction to vertical on EXcell?
<Format> <Cells> <Alignment> tab,
Under "Orientation", drag the Text indicator to either +90� or -90�.
Please keep all correspondence within the Group, so all may benefit!
"bibi" <email@example.com> wrote in message
> How do I change my text direction to vertical on EXcell?
You can also type "Alt-Enter&qu...Can the Date Format be Changed
Is there a way to change the date format in MS Money 2004?
Quite easily, just change the date format in Control Panel and Money should
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email firstname.lastname@example.org especially if it's a UK specific wish.
I do not respond to any unsolicited email regarding Money
"Kevin" <Lundquisk001@hawaii.rr.com> wrot...Case statement vs Change/lookup table
Hello All Gurus,
This is a problem that I have encountered and was wondering what would
be a better approach to the solution
I have a view that is pulling data from a table which is fed from an
external application. Some of the data due to external situations is
wrong/spelled wrong, in the past when this happened I updated another
view with a complex set of case statements. This is fast and stable,
however, it is for only three instances as they are the only mistakes
and they happen always, aka the data is always spelled wrong for these
three instances. Now there is a situation wher...Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?
I have currently in Xcel and long list of X English phrases in one
column with associated numerical data about each name in adjoining
I have on another workbook (which could of course be pasted into this
workbook)another similarly set out column of Y English phrases again
with ajoining columns having numberical data row that the phrase.
I would like to be able to sort the second column of phrases removing
all the phrases that occured in the first column. Ideally it would be
great to have the numerical data for the remaining English phrases
still on the same rows (not necessary ...How do I change currency exchange rates?
I have US stock held in a Cdn investment portfolio. (I also have US stock in
a US portfolio). Money 2006 uses the same exchage rate all the time when I
look at the portfolio manager. How do I adjust the exchange rate for each
day, at month end. It would be great to be able to balance my statements.
Money uses the most recently downloaded rate for all conversions it shows at
one time. You can enter the rate--but it's still only one rate, not a daily
series of them.
To change exchange rates, go to Tools | Settings | Programs settings |
"JennyL...DLookup #Name? Error
I'm trying to have a text field default to a mainframe date format which is
text YYYYMM. If the current month is 3/1/2008 than the default MF date would
be 200802, if the current month is 4/1/2008, than the default date would be
200803, and so on. My table is just two fields: one with the Mainframe date
[CASDate]and one with the current month date [Current]. The formula below is
giving me a #Name? error and I can't figure out why as the fields are named
correctly: CASDate is the mainframe date; dbo_uDateTable is the table that
has the two fields, Current is the current date (3/1...Auto Price change
I have a prospect who wants to have his POS system to automatically change
his item prices according daily fluctuations in the Native currency he is
receiving payment in from his Customers compared to the Foreign currencies he
purchases them in (simply by changing the Exchange rates in the system, not
by any Receiving voucher or manual Cost adjustment). Add to this, he would
like it to reflect the different currency values per item according to the
default currency assigned to the vendor the items came from.
Retail Technology Experts (RTE)
This is a development that we w...Changing Of Column Values ?
Using Excel 2007 and Windows7
This sure seems "funny," and was hoping someone might explain it for me:
In B1 I have the value 154.22
In B2 I have the value 33.74
In E1 I have 154000000
In E2 I have 33740000
I copy from Column E, and do a Paste Special in Column B
Column B looks correct, as it has in:
B1 the value 154220000
B2 the value 33740000
E1 has changed to 1.5422E+14
E2 has changed to 3.374E+13
In the Paste Special dialog box that came up I selected for Paste:
Values, and Operation: None
As the values in B look correct, I'...Change default location of pop up message box
I want to attach a message to the cell that pops up when
the cursor is positioned over the cell. I have created
the message and when I hold the cursor over the cell the
message displays correctly. However, the problem is that
because I have "frozen" rolls and columns (to keep the
columns descriptions in view when scrolling through the
worksheet) that the "frozen" lines show up in the message
Is there anyway to move the location of the message box
when you hold the cursor over it. I already know how to
move the location of the message box when you...Changing the page setup for printing
Currently, when my report prints, it is in landscape.
How can I change it so that it prints portrait and is reduced 75%?
Is it possible to set this up in a macro?
Open your report in design mode and then setup your layout and properties and
you want them to be. In your case goto Page Setup and change the page
orientation to portrait. Then set your page content to fit within the page
boudaries. Save your changes and then this is the way they will be from now
Hope this helps,
For Access ...Last Name, First Name
In version 1.2 we incorreclty set up the database as Last Name, First Name. I
see in Version 3 going forward we change this for new records. Is there a way
I can go into the database and dorrect this to First Name LAst Name, and then
change the format going forward.
In both versions, there is a setting under the system settings to control
this for ongoing updates. Then, you can issue a direct SQL update on the
underlying ContactBase & LeadBase tables to update the fullname field to be
the correct value. Be carefule updating the tables though. This is not a
supported ...Outlook Mail Item Duplicate "Display Name" Problem
I'm currently writing a Persona Menu smart tag in Outlook 2003. I use
dynamic caption and intend to modify the "Additional Actions" sub-menu
depending on the contact(in the MAPIFolder) that the tag is referring
Problem occurs in the mapping of the tag and OL contact. All
information I can find from the smart tag action DLL(with
ISmartTagAction2 interface) is just the tagged text string from
get_VerbCaptionFromID2() but not the entity object that calls the
persona menu. So my way to complete the chain is to :
1) search the sender and recipients' "display...Data Files
How do I change the save location of my money file from
the default location to a location of my choice (an
external usb drive)
Save in: box
Make changes as desired.
Or use Browse button
>How do I change the save location of my money file from
>the default location to a location of my choice (an
>external usb drive)
Thanks. I will give this a try.
>Save in: box
>Make changes as desired.
&...Change how Outlook shows attachments?
Can anyone explain how Outlook decides to show attachments? Ordinary
Word or Excel files.
Sometimes the attachment is inline with the message, actually showing
the file icon (ex: word.doc) in the body of the email.
Other times it will show in the message header, with a paper clip icon.
Now, a user complains, nothing shows at all! The attachmant is there,
and by going to File|Save Attachment I can get to it.
How to control this?
Thanks for any insight or leads!
Check the format of the emails. Rich text will show attachments in the body,
HTML or plain text should show it either at t...Changing bar graph legend?
I am a teacher trying to teach students how to graph rivers in differen
continents and their length. I can get the rivers and length graph, bu
I want the legend to show only the continents (e.g. I have 2 rivers i
Europe and want them both the same colour and the legend to say Europ
for that colour). The only way I seem to be able to include th
continents in this way is for the legend to say both the continent an
the river name, which is a bit redundant since the river name i
already on the x-axis. Is there any way of putting information only i
the legend? I hope this description is clear enoug...Change default sent to program from Windows live mail to OE
When a right click on any file while viewing in Explorer and choose Sent to
> Mail recipient, the default email program that opens is Live Mail, but i
want Outlook Express. This is even after after changing my default mail
handler to Outlook Express. Is there a way to correct this ?
I forgot to mention I use XP ans Outlook express 6
"Daniel as twiggy144" <email@example.com> wrote in message
> When a right click on any file while viewing in Explorer and choose Sent ...change cost rates table
How can i change the cost rate table of resource in project professional 2007
Open the resource in the Resource Pool with MS Project. Doubleclick on the
resource. Select the Costs tab.
- Andrew Lavinsky
> How can i change the cost rate table of resource in project
> professional 2007
...Adding Company Name to Addresses
When you use your Outlook 2002 Contacts folder to insert
a single address into a Word document, only the full name
and the address lines are inserted. How can you
automatically include the Company name in the inserted
To learn about ways to control how an Address is inserted into Word from
Outlook, take a look here:
"Linda B" <firstname.lastname@example.org> wrote in message
news:18f801c48c5f$26cbf8e0$a301280a@...Order of Address Book (name recognition) recipients
I have a question as this is driving me crazy. When I send an email to my
husband and type in his name my outlook express automatically fills in the
rest of the name until I continue to type and it becomes obvious. The problem
is that I have 3 people in my address book with the same first name that I
never email and I want my husbands name to come up first when I type in the
name "Scott". Because the others have names closer to the letter A
(alphabetized) he is not the first one that pops up and I have to keep
typing. How do I change the order of name recognition? Thanks!
Thi...Changing Colour of Bar depending on Value
I am trying to put together an attendence register for some students, th
calculations are sorted, but what I want to do is create a bar graph showing
total percentage attendance but having the bar change dependin on the value.
e.g. if attendance is 100% a Green Bar, if say 80% Amber and if 60% Red.
Is this possible?
Here's a conditional charting approach that uses separate series for each
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions...Macro execution changes filename reference for all macros
Long ago (10 or more years) I created a mailing list application, using Excel
97 originally, with updates along the way using Excel 2000 and 2003. The
application has been running with Excel 2007 for 18 months without a problem.
Everything has worked smoothly until about two weeks ago.
The user clicks on any of a number of control button on a worksheet to call
a series of routines. In the troublesome routine a list is sorted and
filtered. The filtered list is copied to a new sheet. The sheet is renamed.
The sheet is then moved to a new book. The problem occurs when the...Rapid change between companies
Changing companies is very slow in 9.0. Request either significantly
improved switching time or ability to not consume user license when running
multiple instances from same Terminal Server session or same workstation.
The latter model allows user to Alt-Tab between companies which switches
companies very quickly. It is the same user working in only company at a
time but being logged into multiple companies.
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&quo...Preventing changes on inventory cards
I need some help in security - I would like to prevent others from changing
the information in the inventory cards but still allow them to see all the
Where do I go on advanced security to do this?
You need to deny access to the cards and grant access to the inquiries.
That's the easiest way to let people view data and not let them touch it.
> I need some help in security - I would like to prevent others from changing
> the information in the inventory cards but still allow them to see all the
> Whe...External reference changing the link
I have a worksheet full of external references to other worksheets on
I have recently updated to excel 2003 and now when I open the workbook,
the links point to somewhere on my harddrive (c-drive).
How do I get the sheet to point to the network?.. I still have access
to the files on the network.
The consequence is that I cant work in the files, because if I save
them, I completely mess up the links for everybody else.
I hope somebody can help me here.