have to format URL
When I paste a url into an e-mail it comes in as plain text and I then
have to make it a hyperlink
why is this?
What format is the email you're sending? Also, many times the receiving
email program will turn URL-like text into clickable URLs anyway.
"Martin ���� @nohere.net" wrote in message
> using 2007
> When I paste a url into an e-mail it comes in as plain text and I then
> have to make it a hyperlink
> why is this?
what are you doing to make it a hyperlink? at most,...Formatting problem
I am trying to 'improve' the formatting of a workbook containing many
sheets. My basic problem is this. The person who set up the sheets didn't
use text wrap. Once they got to the end of a line (when typing text) they
went onto a new row. They then tried to put borders round the cells but
missed out many cells. The result is a total mess - odd borders everywhere
and text spread over many cells.
I am trying to improve the design. I am trying to put a whole paragraph in
one cell but this is extremely time consuming. It involves cutting the text
from each row and pasting it to the en...Conditional Formatting 02-15-10
I have a date field (birthdates) in column B
In column A I do math on that date field to arrive at age
(Today()-C3)/365) - (Not very accurate but works for my needs)
I would like Column A to be conditionally formatted based on the Date (month
and day) in Column B.
I want the text to turn RED if we are approaching X number of days before
that date (say 45).
How can I do this?
On Feb 15, 8:13=A0am, "Dave" <dave@accessdatapros> wrote:
> I have a date field (birthdates) in column B
> In column A I do math on that date field to arrive at ag...number format #5
number format in excel is normally with "thousand(000)" separators which
gives in millions and thousands
for e.g 1,123,456(one million one hundred and twentythous and four hundred
In India we have a term called "lakh" which is 11,23,456. (eleven lakhs
twentythree thousand and four hundred and fiftysix) This means no. of
digits for separators are in 3 and 2 from right to left. In regional setting
It appears you can have only one number in digit separators and not two
variable separators. custom format also does not help.
any solutions. numbers should rema...How to export a query to then xml-format file via VBA?
I would like to transfer my access query to xml-format, but how can I
do it via VBA automatically?
...Temporary formatting??? #2
I am using a database in Notes. Now while i realize that lotus is th
devil, and that it is worlds apart from excel, I am better than averag
at excel and often the solutions to problems in excel lead me to th
solutions in lotus.
so this question
I have to update the aforementioned database quite often, and wa
wondering if there is a condition format which is applied to =DATE + 3
(or something to that extent)
IOW, I input the new information, and it stays the formatted color fo
30 days then changes to the default text settings or drops the formul
any leads will be greatly apprec...Calendar Formatting
I am using Publisher 2003 to create a monthly calendar that I would like to
print in ladscape mode. The days of the calendar has text that discribe what
will be happening on that day. Is there a way to one, change the format of
the text for all days of the calendar at once and two, change the dimensions
of the boxes for each day so they are all of the same height and width at
once? In other words I would like to change the properties of one of the days
of the week and apply those same properties to the rest of the days of the
week on the calendar without having to change the properties ...Font Format in Axis Labels
Is there a way to format font in axis labels? Like Bold, 12pt, Red
"Phil Hageman" <PhilHageman@discussions.microsoft.com> wrote in message
> Is there a way to format font in axis labels? Like Bold, 12pt, Red
Yes. Format Axis, and then the Font tab.
If you want to format specific parts of the axis labels you will have to
create the labels yourself. See Jon's examples
Phil Hageman wrote:
> Is there a way to for...I can't back space more than one character or repeat a character,
I was prompted while filing out a form to have duplicate key strokes stopped.
I made the mistke of accepting and now I can't type any dupe characters
without difficulty (must pause momentarilly) and I can't back space without
the same pause. I also cannot find how to disable the thing. This happens in
all typing situations, including here.
You've probably enabled FilterKeys, one of the Accessibility Options. You
can turn it off in Windows Control Panel and at the same time disable the
shortcut key that you pressed to enable it.
Suzanne S. Barnhill
Microsoft M...format cells that will show the data in parenthesis
I would like to format some cells that I put data into to be in ( )
Parentesis.. How do I do this?
An example would have been very useful. Assuming it's negative numbers you
want to parenthesize, use a custom format of:
"Hoop" <Hoop@discussions.microsoft.com> wrote in message
>I would like to format some cells that I put data into to be in ( )
> Parentesis.. How do I do this?
...Format Options for Integers
Currently, all integers in MSCRM ar formatted to show a comma. This is
problematic in many scenarios. will the next release include the option to
format Integers with/without commas (field level)?
I recall that previous versions of Access were smart enough to capitalize the
first letter of each sentence when adding information to a memo field but
Access 2007 is incapable of this. Is it possible to accomplish this task in
an easy manner. Some of you may suggest using "Autocorrect" but it just don't
work. Try adding text in a memo field and you will see. Type a work and end
with a period. Begin a new sentence and as soon as you press the space bar
the previous word will be capitalized.
Again, any suggestions how to do this?
I tried and what i see is that only the fir...enhanced conditional formatting
i want a conditional formatting system that is not limited like the current
one. currently i can only set 3 conditions and the formating settings for
each condition being true in the following scenario i would require 6
conditions that would require the values of more than 1 row/column to be of a
specific value to create the desire effect. they are as follows:
1) if drivable is = yes and elapsed between 0 and 6 cell shadow green
2) if drivable is = no and elapsed between 0 and 3 cell shadow green
3) if drivable is = yes and elapsed between 6 and 9 cell shadow orange
4) if drivable is = no...default cell format
Is there a way to set a "global" cell format such that when I enter a
date, it's automatically set to the format I like to have, without
having to re-format every cell?
I'm not familiar with the newest versions of Excel, but I expect the
process is similar to EXCEL97 with which I'm familiar.
Construct a spread sheet with the desired format and save it in the
Template directory as "CustomDate.xlt" On my machine, Microsoft's
installation program placed those templates in the directory:
"C:\Program Files\Microsoft Office\Templates"
Subsequent...Autocorrection bug in PowerPoint
Using PowerPoint for Mac v.10.1.5 Swedish on iMac OS 10.3 - Whenever
I write letters "f�" (f plus scandinavian letter o with two dots
above) autocorrection adds a dot behind each letter - also when I
type a space behind the last letter. I can't change it where I
normally change or add autocorrections. - The problem does not appear
in MS Word.
- Suggestions anybody?
...Why won't my conditional formatting display in the cell
In Excel, I create a conditional formatting to highlite a duplicate
refference. The formatting applyied, as indicated when I click conditional
formatting again, but does not display in the cell. I am useing Office 2003.
I applied a red patern with white bold, but the cell does not display any
You need to post your conditional format formula.
"Cashius War eagle" <Cashius War firstname.lastname@example.org> wrote in
> In Excel, I create a conditional formatting to highlite a duplicate
> reffe...Conditional format #22
I am making a training schedule, and I need a bit of help.
In each workbook, I have 12 sheets 1 for each month.
Let’s say Joe is up for retraining on March 1. In cell C46 of every month I
have his due date of March 31. The way I have it working right now is if 30
days prior and the training is still not done, the cell with the training
date in it (C46) turns yellow. If it expires it goes red. What I would like
it to do, is if 30 days prior the training is not done I would like it to
turn Cells A1-A30 B1-B30 C1-C30 yellow. If it expires I would like the same
cells to turn red. Is this p...Date Formats for Cells Do not match System Date Formats
Operating System: Mac OS X 10.6 (Snow Leopard)
I have just loaded Office 2008 and then update to the latest update 12.2.4 <br>
I have my system preferences set to Australia for date and time using the date format dd/mm/yyyy. But in Excel when I open the format cell dialogue and select date the only formats available for selection are in the mm/dd/yyyy formats. When I checked in "Numbers" the dd/mm/yyyy format is used so "Numbers" is picking up the system preference why not the excel.
Did you by any chance have ...Convert string into XML format
I have a big problem, i'm using XMLdocument to add elements to a XML file.
Elements are like this:
<comment>this is <a comment></comment>
<description>In italian "is" is = � !</description>
the problem is that i want to encode text in name,comment and description.
I have tryed to use InnerText property, but it doesn'work for encoding (like
was written on a msdn example...................)
Any idea ?
> I have a big problem, i'm using XMLdocument to add elements to a XML file.
>...Formating numbering in Publisher
I am trying to change some bullet poins into a numbered list. So I put my
cursor at the start of the line of text, and press the numbered list icon. It
turns it into a numbered list, which is what I want it to do (as I go to each
line I have to start the numbering at the next number in sequence, but that
The trick is though, sometimes the numbers are bold, sometimes the numbers
are normal. How can I make them all bold or all normal (The text is all
Thanks so much!!!
> I am trying to change some bullet poins into a numbered list. So I
Is there a way to make sure all names in a column have the first letter
upper case, and all other letters lower case? I believe you can in
Access, but couldn't find the same option in Excel 2002.
amab19's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29730
View this thread: http://www.excelforum.com/showthread.php?threadid=554419
Will turn first letter to a capital
All Out...more than 3 conditions in conditional formatting
Is it possible to have more than 3 conditions using conditional formatting?
I am dealing with text and not numbers which makes it a little harder to
manipulate. I want up to 10 conditions.
Can anyone advise? Cheers, rob
There is a tool on the net called CFPlus which lets you use loads.
Try out www.xlDynamic.com
"rob curtis" wrote:
> Is it possible to have more than 3 conditions using conditional formatting?
> I am dealing with text and not numbers which makes it a little harder to
> manipulate. I want up to 10 conditions.
> Can anyone advise? Chee...Mail is received in Plain text even formatted and sent in HTML
MS Outlook is automated to send out an email in HTML but when the email is
received from MS Outlook it is in plain text.
The email in Sent items is in HTML format.
If an email is created from MS Outlook itself(not programmetically) in HTML
and sent, when received it is in HTML format.
Following is the configuration of this computer
- Windows 2003 enterprise edition x64
- MS Outlook 2007 with excahnge server
- Logged on to the server using a Cirtix session
- Default email application of Windows is set to MS Outlook
In a Windows 2003 standard edition x64, with MS Outlook 2...Can one save Autocorrect settings?
I have had the need to reformat my hard disk several times, and
Every time I do that I loose my Autocorrect settings!
Is there a way to save - say to a floppy - my settings so I don't have
to try to remember what terms I used before?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Dana DeLouis wrote a couple of macros to transfer AutoCorrect entries.
The first one dumps them onto a worksheet. You can check them there.
Copy the workbook to the...Format or Erase DVD/CD
Unable to fully format or erase
Any programs in the net I can use?
Erase a CD or DVD:
> Unable to fully format or erase
> Any programs in the net I can use?
Leroy thank you
But I use this method and it never fully erases my DVD or CD
"Leroy" <email@example.com> wrote in message
> Erase a CD or DVD:
> JMed wrote: