Paragraph formating jumps to defaults.
We are using Office/Outlook 2007
We have an email signature script that is run when users login, it´s working
ok except for two things;
If the default paragraph settings in Word 2007 for a user matches those in
the signature script, the signature will use the "Base defaults" of Word
2007, that is SpaceAfter = 10 and LineSpacing = "Multiple" with a value of
So if I change the script to use SpaceAfter=0 and the user has set his/her
Word 2007 to use SpaceAfter=0, the result will be SpaceAfter=10.
If the script is set to SpaceAfter=0 and the us...Where is the lasso feature in 2008? (was in formatting palette in 2004)
Operating System: Mac OS X 10.5 (Leopard)
Hi, <br><br>In Excel 2004 in the formatting palette in image, there are different selection marquees and lasso's. Where are these features in 2008 Excel? I can't find them anywhere. <br><br>thnx
I just found my answer, the "genius's" at Microsoft / MAC Office decided to kill off all these editing features... <br><br>Over $200 to upgrade to a product with LESS features... I don't think so... unbelievable, I will continue to use 2004 because 2008...Formatting a subtotal line with a macro
I already have in use a macro that runs a sort and subtutal function. I
would like to format the subtotal row using visual basic since there is
already a macro in place.
Look at this:
ActiveCell.Font.Bold = True
"DJDKAL" <email@example.com> skrev i meddelelsen
>I already have in use a macro that runs a sort and subtutal function. I
> would like to format the subtotal row using visual basic since there is
> already a macro in place.
This is what I've g...formatting auto replies
Does anyone know of a method that allows outlook 2k2 to format automatic
replies regardless of the format of the original message? I setup this
automatic response rule that replies with a template, but problem is, when
replying to http clients (hotmail or yahoo), the message at the receiver's
end has words totally misplaced, all over the page. Any suggestions would be
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Format for credit card numbers
I've tried a custom format for entering credit card numbers (four groups
of four digits, separated by dashes: xxxx-xxxx-xxxx-xxxx.
I have tried to use ####-####-####-#### and 0000-0000-0000-0000 but
each of these causes the last digit to change to zero. So if I enter
5415779800902512 I get 5415-7798-0090-2510.
Anybody already solved this problem?
Schmacker's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28041
View this thread: http://www.excelforum.com/showthread.php?th...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...XY Scatter Map with Test Labels
Sorry if this is a repeated request, but I'm trying to show the distribution
of 16 points (labelled A through P) using X-Y coordinates. When I turn on
labels, I can show either the X-positions (label) or Y-positions (value), but
I really want to show the text name "A" through "P". Can this be automated
Thanks for any advice.
The easiest thing to do is use a free addin utility to allow you to link
data labels to cells.
Try Rob Bovey's XY Chart Labeler add-in
Mike K. wrote...What is the technical reason for native mode requirement of the domain?
.... what is the technical reason, why CRM can only be installed in a domain
in native mode?
It's for supporting group nesting which is used in MS CRM.
IMO and as far as I know, it is the only reason for the
native AD requirement.
>.... what is the technical reason, why CRM can only be
installed in a domain
>in native mode?
Nicolas Hognon wrote:
> It's for supporting group nesting which is used in MS CRM.
> IMO and as far as I know, it i...Varying format
Is there any way to format a cell differently depending on the number of
decimal places typed in? What I need is a minimum of 2dp but 3 if the typed
entry matches. eg 1.2 appears as 1.20 and 1.234 appears as typed.
Try formatting the cell with a custom number format such as 0.00##
AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478
View this thread: http://www.excelforum.com/showthread.php?threadid=27494
"AlfD" <AlfD.email@example.com...Setting appointment start & end time increments format
In Outlook 2002, I can easily set the Day View to display
the time increments in 15 minute blocks, but on the
Appointments form, the Start and End Times available on
the drop-down menus, respectively, are in 30 minute
increment blocks only. How can I set the format for the
appointment page to have the Start and End Times for
appointments have increment time blocks of 15 minutes?
Thanks! My direct email address is:
If you set your appointments in 15 minute blocks
Outlook will start to offer that. It takes a few uses
Nikki Peterson [MVP ...Time Format Question
I currently have time entered like this:
I need to look like this:
I've done a ton of research but nothing has worked so far.
With your values in column AA, try:
Gary''s Student - gsnu201003
> I currently have time entered like this:
> I need to look like this:
> 5:35 p.m.
> 9:02 a.m.
> I've done a ton of research but nothing has worked so fa...difficult format
I want to format a code like this: ##.0001.## so then i push it down and gives me 0002 and so on, the other ## r numbers. The problem is that when i do that, it sums in the last two numbers instead of what i want, so i ask if it is possible to format like this: (text)##.(number)0001.(text)## so it guives me the sum of number then do what i want. if it is possible how ca i do that?
You can try this, starting in row 1:
You'll have to adjust the "Row()" number when starting in any other row.
For example,...how do I change date format in the header in Excel XP ?
I need to chage my date format, in the header to Day; Month DD, YYYY
ie. Saturday; May 23, 2005.
Woudl you please help me out ?
Check this out.
but change the format to "dddd, MMMM dd, yyyy"
"Hesam" <Hesam@discussions.microsoft.com> wrote in message
> I need to chage my date format, in the header to Day; Month DD, YYYY
> ie. Saturday; May 23, 2005.
> Woudl you please help me out ?
> Thank you.
&g...Formula to display nearest following Thursday in mm/dd/yyyy format
I have been reading and trying different suggestions here to no avail. What
I need is a formula to calculate the nearest following thursday, and display
it in mm/dd/yyyy format.
To be clear, I have a column of varying dates. I need a formula to return
the next thursday for each of those dates.
To illustrate, say I have 05/22/2010, 05/23/201, 05/24/2010, & 05/26/2010 in
cells A1 through A4. In cells B1 through B4, I would like to see 05/27/2010,
05/27/2010, 05/27/2010, & 05/27/2010 representing the following thursday.
Thank you for your help!
T...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Printing problem in booklet format
When I try to print my booklet document, on the screen it looks perfect, but
when i go into print preview it only has half of each page on the paper.
When i print, it comes out exactly like that. I have Publisher 2003 and run
it on XP home. My printer is an Epson stylus Photo RX650. I contacted Epson
and they say its a Publisher problem. Any suggestions.
Are you selecting booklet in page setup? Do you ...vb date and ssn textbox formats
Ok, so maybe I am crazy...but I have checked "Visual Basic 6 how t
program", and "Visual basic 5 teach yourself in 24 hrs" for and exampl
or how to format a text box on a user form to accept and display date
and Social Security Numbers in the specified format.
Message posted from http://www.ExcelForum.com
TextBox1.Text = Format(Date,"dd mmm yyyy")
TextBox1.Text = Format(mySSN, "000-00-0000")
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mai...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...Missing Data Options
I am trying to use Tools - Options - Chart. I want to use the "not
Plotted" option. When I click on it my chart does not change. This
happens after I've selected the chart and then trying to make these
What am I doing wrong?
I want to create a chart that ignores missing data, and gives me a
trend line based on the data I have.
I've had my nose in my Excel "bible" but can't find the answer.
I greatly appreciate any tips.
jimsmith888's Profile: http...Extracting data and returing to colums.
I am about half way there, but I need some more help.
These are web inquires that parsed out in the same colum and repeat th
same way all down the page.
I want to be able to use the fields as guidelines to pull the dat
adjacent to it and sent to the new colum. In a way it is transposin
all the data, but I need to pull all the first names of these peopl
and have them align in the first colum. Same for Last name, business
So if the information that I have come across like this in th
spreadsheet, I just want the customer infomation to move to th
appropriate colums like the third example...how do I convert Mozilla thunderbird data to outlook 2010?
Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
Outlook and would like to switch back. Can't seem to see a conversion utility
I suspect you export from thunderbird to a format Outlook can import, eg csv
(assuming pop mail)
"Mishka" <Mishka@discussions.microsoft.com> wrote in message
> Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
> Outlook and would like to switch back. Can't seem to see a conversion