Can I fix the exponent in scientific/engineering format?
This is sort of a continuation of my search to find a ppm number forma
Found someone who mentioned using engineering formats (kind of a
extension of scientific format). After a little tinkering, here's wha
I've found (using the values of 7E-3 and 7=-5 as examples):
format 7e-3 displayed 7e-5 displayed
.0E+0 .7E-2 .7E-4
0.0E+0 7.0E-3 7.0E-5 (REGULAR SCIENTIFIC NOTATION)
#0.0E+0 70.0E-4 70.0E-6 (EXPONENTS ARE MULTIPLES OF 2)
##0.0E+0 7.0E-3 70.0E-6 (EXPONENTS ARE...highliting works on with html format?
Here is what I would like to do:
In outlook, suppose I get a message in plan text format.
I would like to open the email, and maybe make some sentences bold and colored.
and then I can save it. Hence after sometime the email will be noticable for me.
Now, I can do this if the e-mail is sent in html format cause then I open the
message and then I press "edit message" and the edit toolbar becomes
usable and I do things on the email.
However, if the email is sent in "plain text" format, I can not edit the email at all.
I try to push the "edit message" butt...Changing the fields the LOOK FOR facility uses
Ive had a good look round the system and dont think this is possible,
just wondered if anybody else has any ideas.
The issue is as follows :-
If I go to the default cases view (All Cases), I can see all cases
against all accounts. I would like to be able to Look For all or part
of an account name (or potentially other fields) to quickly filter this
Is it possible to alter or add the fields that the Look For facilty
will use to return results? or Can an advanced find use take arguments?
Go to Settings - Customization, and customize the Case enti...changing SMTP Port
I am working on securing my Exchange 5.5 server on the SMTP port level.
I have a box in the DMZ that listens on port 25 and then sends on port
1025. My internal email firewall inside the core listens and sends on
port 1025. I have modified the service file on the NT 4.0 server wher
my Exchange 5.5 is installed to show SMPT port as being 1025. I
rebooted the server and test. I can send email to the exchange server,
it is listening on port 1025 but is only sending on port 25.
Is there a way to configure the Exchange 5.5 server to listen and send
on port 1025?
Thanks for any help given.
...Number formatting issues
An ongoing issue I have had is with one of the columns in the reports I
am accessing. One of the fields I access has a numbers in it such as
"063740285007037" but when they are copied and pasted into another sheet
"6.37403E+13" is displayed. Is there any way to correct this after the data
has been pasted?
Thank you for your help.
Change the number format of that range.
Select the range to fix
Format|cells|Number tab|custom category
(as many as you need to keep the leading 0's)
Or maybe you could paste a second time:
Edit|Paste special|p...Change Name in OWA
I had a question about OWA with exchange 2007. Do users have the ability,
through the GUI of OWA, to change their first and last names that are set in
"supersonic_oasis" <email@example.com> wrote in
> Hi all,
> I had a question about OWA with exchange 2007. Do users have the ability,
> through the GUI of OWA, to change their first and last names that are set
> Active Directory?
...Formatting 0 values to show blank cells
I am using the =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) to return a zero value.
For printing purposes I need the 0 to not show in the cell (blank cell). I
can do this by using the accounting format, but a dash (-) still shows in the
cell. The sheet is protected to protect the formula. How can I protect AND
not show anything in the cell WHILE keeping the value at "0"?
You can use set the custom format to
See Worksheet and Excel table basics > Formatting numbers in Excel help file
> I am using the =...Change default "SaveAs" to *.msg rather than *.html
I regularly need to save emails and prefer to save as *.msg so the
attachments etc are contained within the one file.
How can you change the default SaveAs command to Save as Type in a *.msg
format (rather than *.html) so the type is already *.msg without having to
use the pull down?
It would be nice to know what mail client you talk about :)
"TroyB" <firstname.lastname@example.org> wrote in message
> I regularly need to save emails and prefer to save as *.msg so the
> attachme...How to change a Macro based on content of a cell
I need to import a text file into a spreadsheet. I can do this manually by
doing File > Open > then select a text file. Then Excel goes through the
Text Import Wizard
I can automate this by recording a Macro in Excel. The macro looks like this
(Excell wrote that for me, I did not):
Workbooks.OpenText Filename:="C:\DrillData\" + "MOR701.pck",
StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1),
, 1), Array(26, 1), Array(37, 1)), TrailingMinusNumbers:=True
How can I change ...Changing Fold Position
Publisher appears to favour top over side fold (for landscape cards) - I'd
like to make some side-fold cards, but I can't seem to change the position
of the fold. Any way to do it? I've had a request for side fold cards, and I
can't let the customer down! Side fold are also more stable when displayed -
tent cards tend to collapse I've found, book fold are more stable because
there's less weight (or something!)
And you all should know what version I'm running by now! If you don't, I
ain't gonna tell ya! You'll just have to look through my posts! <eg&g...remove Print Display
Operating System: Mac OS X 10.6 (Snow Leopard)
I can not remove the Big Blue Print Display words pasted on my xcel sheet. When I save and send to others it is still there, making it difficult to read text
There is nothing in Excel that would cause anything like what you've briefly
described to occur by default. It would have to explicitly have been created
by someone working in the file. With no more detail than you've provided
though there are only 2 possibilities that come to mind.
The first is that someone has added some sort of graphic or text to the
Hea...Need help with format
I have 2,000 players in football pool game. What would
be a format I'd use. How will I be able to find the
player with the least amount of mistakes?
Assume names are in column A, count of mistakes in column B
if there is a tie for least amount, the player in the lowest numbered row
with the least amount will be shown.
Also look in Excel Help for the RANK function.
R2ri <email@example.com> wrote in message
> I have 2,000 players in football pool g...Excell Cells: Auto Formatting
I have protected a workesheet and unfortunately when the people submit
information on the cells and it is too long than the actual height of the row
and it wont extend. What can I do?
When protecting the sheet allow users to format cells and rows.
Gord Dibben MS Excel MVP
On Tue, 9 Feb 2010 13:14:01 -0800, Sophie <Sophie@discussions.microsoft.com>
>I have protected a workesheet and unfortunately when the people submit
>information on the cells and it is too long than the actual height of the row
> and it wont extend. What can I do?
How do I jus...Keekp track changes
I have excel with 100 records which will be update my another person.
I would like to keep what have been change for that 100 record, any tools to
track or how to do it ?
You can use a macro that will automatically insert a comment in a cell giving
the date and time whenever the cell is changed:
Install the following event macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Set r = Target
Gary''s Student - gsnu200838
> I have excel with 100 records which will be update my anothe...How to format number with mixed number and text?
I put the following formula into a cell:
=6.65+0.15&" lb". It did what I intended, namely:
add the numbers and display the result with the
tag, i.e. "6.8 lb".
However, the Number format seems to have no effect
on the displayed result. For example, if Decimal
Places is 2, the above result is still "6.8 lb",
not "6.80 lb". I get more decimal places only if
they are "needed". For example, =6.65+0.1511&" lb"
displays 4 decimal places, even if the Number
format is 2 decimal places.
How can I control the format of the numeric ...how do i change the programme in which hyperlinks open?
I have a database contain tables with hyperlinks to documents that open in
Adobe Acrobat. I want them to open in the Standard version of the program, so
that they can be printed. At present they open in Reader.
Are these documents you are trying to open .pdf files?
MCP, MOS, MCAS
> I have a database contain tables with hyperlinks to documents that open in
> Adobe Acrobat. I want them to open in the Standard version of the program, so
> that they can be printed. At present they open in Reader.
...Counting conditional formatting
Re my earlier post, I am tring to fond a formula to count those cells that
have been formatted by conditional formatting.
On Sat, 16 Oct 2004 17:13:01 -0700, "Peter" <Peter@discussions.microsoft.com>
>Re my earlier post, I am tring to fond a formula to count those cells that
>have been formatted by conditional formatting.
I have no idea what your earlier post was, as this post appears in a thread by
But to count those cells that have been formatted by conditional formatting,
you will need to use the same formula that you used for the conditional form...Excel cell display
I want a text box to display when I click on a particular cell - how can I
make that happen?
work for you?
> I want a text box to display when I click on a particular cell - how can I
> make that happen?
Yes, thanks - I found that after I posted of course (newbie to Excel). I was
looking to see if there was a macro I could gen to do the same thing...
> Insert> Comment
> work for you?
> "slantt" wrote:
> > I want a text box...datetime field display
Have a form with a table as Record Resource. There's a datetime field in
the table which I would like to break down programmatically and display in
two unbound controls: a "hour" combo box and a "minute" combo box. If the
user selects other values in the combos, I would like to update the datetime
field accordingly. I prefer not having the user to touch the date portion
of the datetime field.
What's the "proper" way to implement this? Do I need to initiate another
read of the record to populate the unbound combos? If so at what poi...How can I sort and maintain formatting?
I have a very large excel doc (well over 1,000 rows, by 30 somethin
columns) that require formatting (resizing the row height) each row b
hand. I have done all of that tideous work, but now I need to sort b
multiple columns, and when I do that, the formatting of the cells i
not maintained. (The size of the row stays, rather than moves with th
data) Please tell me there is a remedy and I haven't just wasted m
time formatting for nothing! Thanks for any and all advice
littlelostgrl's Profile: http:/...Change Text color using CListCtrl
Does anyone know how to change the color of text for a single row only
in the mult-column ist box using CListCtrl.
"Ririko Horvath" wrote:
> Does anyone know how to change the color of text for a single row only
> in the mult-column ist box using CListCtrl.
> Thank You
...POP downloading but not displaying email
I recently installed the Outlook Connector to Windows Live mail account (although I do
not know if this has anything to do with the problem).
Suddenly, when downloading pop email, the email never actually reaches my Outlook
mailboxes. Some email does but the vast majority of it doesn't. On the bottom right of
Outlook, it shows downloading of messages but then the messages just disappear. I have
looked in the junk folder, deleted folder, even the draft folder but the downloaded
messages aren't there.
I deleted all of the filters.
At this point I don't know what else to do...Conditional Formatting in Excel 2007 #2
I have been asked to prepare a spreadsheet that uses conditional
formatting on another cell. What it needs to do is that is a cell
contains a particular value i.e. between 2 and 6 the adjacent cell
will turn say blue, but the issue is that there is up to 6 different
rules that could be applied to that one cell. All of these rules then
need to work for the subsequent entries.
If anyone could help me with this issue I would be very grateful.
On Tue, 19 Oct 2010 03:10:07 -0700 (PDT), didi <firstname.lastname@example.org>
>I have been a...Charts change the place
I have some files created in Excel 2003 but when I open them in Excel 2007
many of the charts change thier place. Once I set the place and save the file
and again when I open the file I face the same situation.
Is there a solution of this?
...Lead Activity regarding field display is blank
When I attempt to create an activity from a lead, the regarding field will
not display the original lead. The lead is there, because I can click on the
lead icon and reference the original lead, but the lead subject field will
not display. I am logged in as administrator so I have full rights.
Any suggestions are appreciated
Never mind. I sovled this. Workflow related issue.
> When I attempt to create an activity from a lead, the regarding field will
> not display the original lead. The lead is there, because I can click on the
> lead icon an...