NumberFormat not getting changing onFly changing the regional sett
Hi Excel experts ,
Sorry for posting a new question over here. I am having a hard time with one
of a Excel related issue.
1) User pulls some data ( includes numeric,Date fields ) to excel when
he/she is with German OS settings.
Date show in following format: dd.mm.yyyy ( eg: 23.09.2010)
2) Now on the fly he/she changes the OS regional settings to En-US
3) Here our code again reformats those columns with current regional
settings and polish the data according to its regional settings.
4) In our case all numeric values are getiing changed correctly to the ...Change Fileas name to first name last name
Where can I change the settings so that the contacts filed as First Name last name instead of Last name,First name
OL2002: How to Change the File As Field for All Contacts
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of included script samples are subject to the terms specified at
"Jason" <email@example.com> wrote in message
news:7F277C...Copying junk senders list
In Outlook 2000 and 98, how do you copy a junk senders
lists to put on another client account?
...Writing programs for the manipulation of data cells?
I'm new to Excel and I think I can do this with macros. In that case, where
can I find a list of Excel functions?
On 18 Mar, 10:38, "Scott H" <nospam> wrote:
> I'm new to Excel and I think I can do this with macros. In that case, where
> can I find a list of Excel functions?
Have you tried the help?
I would also highly recommend Chip Pearson's site:
The great thing about Excel is there are so many high quality advice
sites that are easily found.
I like to move my MS optical trackball with my fingertips. This means having
it "upside down" (cord towards me). On my previous computer, XP provided
settings > control panel > mouse > activities which included an "orintation"
setting. My newer one doesn't have "activities". Is this something to do with
Hugh Momoka wrote:
> I like to move my MS optical trackball with my fingertips. This means having
> it "upside down" (cord towards me). On my previous computer, XP provided
> settings > con...Change the mail path
My IMAP server is UNIX-based, my e-mail is stored in its own directory in
user home directory-for example: ~username/Mail. i have windows -xp in
compaq system. which is part of lan. i want to change the path of default
mail(i.e where d mails r saved.) please help me out.
The instructions gvn in help is not able to help me out.
Thanx in advance..///
> My IMAP server is UNIX-based, my e-mail is stored in its own directory in
> user home directory-for example: ~username/Mail. i have windows -xp in
> compaq system. which is part of lan. i want to...How to change font in Status row and Tooltip
Is it possible to change the font in the status field and on tooltips that
I'd like to change to a font that can display Cyrilic characters.
Thanks in advance!
...Determining Changes between an Old and Updated Database
Each week, I recieve an updated database and would like to be able tocompare the new database to the old one to determine exactly whatchanged from the new to the old. Any ideas? Set up linked tables so you can access data in one database from theother; and then use queries (especially but not only Find Unmatchedqueries) to examine the data. On 5 Mar 2007 09:49:27 -0800, firstname.lastname@example.org wrote:>Each week, I recieve an updated database and would like to be able to>compare the new database to the old one to determine exactly what>changed from the new to the old. Any ideas?--John Nur...Understanding complex IF Formula within IF formula
I do not know what this formula is doing can you help?
Thanks for your help.
The formula is looking at a worksheet called QBCash
Breaking the formula down
1. It looks at the contents of B2 and if the word 'Total' are the first 5
letters of the cell the formula return a null string
2. If that isn't TRUE it then checks if B2 is blank and if it is it returns
the value of...Users locked out after changing password
We are issues with users changing their passwords in Dynamics GP, existing
the application, and upon logging in again with their new password, getting
immediately locked out of the system. They then have to be unlocked at the
sql level, but upon changing the password, the same thing happens.
We have Enforce Password Policy on, and we are on SP3 of Dynamics GP.
Does anybody have any insight to resolving this issue?
It is possible that the user is getting locked out as they have changed so...adding pictures/logos to crm or changing colors etc
does any one know if it's possible to incorporate pictures or logos to form
or the CRM UI as a whole, if so how would i go about doing this? also is it
possible to change other features of its appearance such as colors...?
The place to start might be by looking at the cascading
style sheet template that is documented on the SDK - this
is really meant to provide a base for building other web
sites in the style of MS CRM.
>does any one know if it's possible to incorporate
pictures or logos to form
>or the CRM UI as a whole, if so...How can I change worksheet direction from right to left
I want to change the direction of the work sheet in Excel 2007 from left to
right and vice versa
If you mean you want to change the direction of the cursor on Enter, then
click on the round logo top left, select Excel options, select Advanced, and
change the direction to Left, Right, Up or Down as you desire.
Replace xxx with hotmail
> I want to change the direction of the work sheet in Excel 2007 from left to
> right and vice versa
I believe the only way is to go through Microsoft Office Tools and make the
setting ...how many characters i can put into one cell in Excel
If i typed a whole paragraph into one cell of Excel, only a part of para show
up in that cell. I tried wrap text, increase the height of the column.
Any one have idea about it or there are some limit to view in Excel in one
Search for 'specifications' in Help:
It says '32,767 characters. Only 1,024 display in a cell; all 32,767 display
in the formula bar.'
"Gary" <Gary@discussions.microsoft.com> wrote in message
> If i typed a whole paragraph into one cell o...Cant change calendar background color
Hello. I am on a Windows xp pc running Outlook 2003 all patched up in a
windows/exchange client/server environment. I have ownership rights to
another exchange mailbox. I just need to know if there is a way that I can
change the background color of that secondary calendar so that it is
different from my own calendar. The help menu in Outlook says > on the Tools
menu, click Options, and then click Calendar Options. Under Calendar options,
in the Background color list, click the color that you want. Easy enough.
However, even if I put the focus on the secondary calendar and change the...Reflect cell contents into another worksheet #3
I have forgotten how to reflect data that is present in one worksheet
cell into a specific cell of a second worksheet. IOW, repeat cell
contents in a second worksheet.
I simply do not make use of MS Excel97 often enough to remember the
~ Vince ~
You can just type = and then click the cell if you want to be duplicate.
> I have forgotten how to reflect data that is present in one worksheet
> cell into a specific cell of a second worksheet. IOW, repeat cell
> contents in a second worksheet.
> I simply do...building an external link based on a cell value
I would like to build an external link in a spreadsheet
that automatically changes based on a cell value.
For example, I have the following link:
=SUMIF('[Location Income Statements 2004.xls]Mar04'!
$14:$14,P5,'[Location Income Statements 2004.xls]Mar04'!
Instead of Mar04 in the formula above, I would like to
use a cell's contents.... cell A8 for example.
Is this possible?
You can use the INDIRECT function.
=SUMIF(INDIRECT("'[Location Income Statements 2004.xls]" & A8 &
I'm trying to add a formula in a cell which will leave
the cell blank if column A is blank. I use the following:
ActiveCell.FormulaR1C1 = "=if(+RC[-10]>0,2.5,"")"
but I get a run-time error (1004). I know the problem is
the quotes in the third argument. I tried replacing the
quotes with zero and it enters zero correctly with no
error. But I need the cell to be blank, not zero, if
column A is blank.
Try four quotes instead of two:
HTH. Best wishes Harald
Followup to newsgroup only please
...new emails don't show without clicking send-receive
new emails don't show without clicking send-receive
button--and now I've lost the send/receive button. What
do I do?
...Getting any formula to stop at the next blank space
I frequently write VLOOKUP and SUMIF formulas for my spreadsheets an
have found myself typing the same thing over and over. How can I ad
in a command that makes each formula stop at the next blank. I als
have to make the formula references "absolutes". What I'm wanting t
do is copy and paste the same formula down without sacrifices th
ajpowers's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=940
View this thread: http://www.excelforum.com/showth...Font size changes in Excel 2003 charts when re-opened
For certain charts that I create within Excel 2003 (usually bar
charts), I use a font size of 8 (eg for data labels, axis labels, and
scale). If I close the file and then re-open it, all these fonts will
have become size one (title and legend are not effected).
Oddly, if I have created a bar chart and made several copies of it
within a worksheet, it will only be the original and not the copies
that are affected by this.
If anyone can shed any light on why this may be happening and how it
could be fixed, I would really appreciate it.
...Using VBA to change Excel layouts
Our company has designed 4 different spreadsheet designs. The same
data gets stored in any of the 4 spreadsheet layouts....the only difference
is that some spreadsheets use different colors, have different fonts and
cell sizes and etc...
I thought it would be nice to create just ONE spreadsheet that contains
a combo-box or list-box or drop-down box which allows the user to
select 1 of the 4 layout choices, then I want VBA to programattically setup
the spreadsheet layout according to the users choice. Does that make sense?
Does anybody know any good ways to implement something lik...Linking a cell to a chart title
How do I link a chart title to a cell reference in another
worksheet? I have over 200 graphs in one spreadsheet and
need a quick way to update the titles when mgmt changes
for each sales team.
...Office updates changing Outlook settings?
Has anyone experienced some of their Outlook settings changing when
doing Office updates?
Which settings were changed, can you be more specific please. I have not
seen where doing a general Office Updates changes the standard settings.
President, San Diego Outlook User Group
MVP - Microsoft Outlook
"Jerry" <email@example.com> wrote in message
> Has anyone experienced some of their Outlook settings changing when
> doing Office upd...Naming a cell
This was a question given on a Excel test I was given.
To name a cell or range of cells, just select the cell(s) and
enter the name in the Name Box, located to the left of the
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Rita" <firstname.lastname@example.org> wrote in message
> This was a question given on a Excel test I was given.
"Rita" <email@example.com> wrote in message
news:03cb01c3c630$17c56c50$a00128...the font changes colour on emails I send
I am sending an email and the font looks correct. When
the recipient receives it some of the text is bright
green. It doesn't happen on every email but when it
does, it is only on part of the text.