negative number format
I have a report uploaded to excel from a particular program used here at
work. In that program, negative numbers have the format of $###.00-, with
the minus sign at the end instead of the beginning.
When the data comes over to Excel the minus sign is still at the end of the
number. The text currently has a General Format with No Specific Number
Format. I have been manually moving the minus signs to the beginning in each
cell, then changing the Column to Currency Number Format which is very time
consuming. Is there a formula I can use in the Cell, Column and/or Worksheet
containing...Change date format to European format
My computer is set to European date format but Excel is default to American
date format. Can someone advise how to change this default setting.
Have you restarted Excel since setting the system date formatting? Excel
takes its cue from the OS on launch. Also, double-check the Regional setting
in the System Prefs.
If those aren't the cause you'll need to be specific about your version &
update levels of both Office & OS X plus any other details you can supply.
"Scott" <NoSpam-Scot...Formatting just some rows
Thank you so much for that, it'll save loadsa time. I adjusted the formula
as the original sheet contined 11 columns of data.
Can you help with this part now?
The original sheet had dates in Column E (in the form Jan-03). Thay have
come through on the new sheet in the single column as 5 digit figures such
as 37622. Is there any way of getting
the original form of the date back, affecting just rows 5, 16, 27 etc...of
the new sheet? Perhaps I need to format just these rows on the NEW sheet.
A similar problem exists with column I of the original where the � sign has
been lost. Again is t...email failure!!
Can't send reply messages on craigslist.
How do you normally send emails, via webmail? If so, who is your mail =
Gary VanderMolen, Microsoft MVP (Mail)
"Jojo" wrote in message =
Can't send reply messages on craigslist.=20
"Jojo" <Jojo@discussions.microsoft.com> wrote in message
> Can't send reply messages on craigslist.
...Outlook 2003 opens emails in background.
Hi. I'm experiencing a problem where Outlook 2003 will start opening
e-mails in the background after a while. I am not sure if this is
related to other applications being started or stopped (maybe word,
which is set as the e-mail editor?), but haven't noticed any direct
The system is running Windows XP SP2 and is connected to Exchange.
Exiting Outlook and re-opening it will reset it so that e-mails once
again opens as expected--in windows that are in focus.
I found a similar problem reported here, but with no replies:
http://groups.google.com/group/microsoft.public.o...Emails not being delivered
I have a weird problem. When I try to send emails from
outlook, I get the "email sent" notification and the mail
moves from the outbox to the sent items folder. The email
is however not delivered to the recipient. When I tried
sending a test message from the email account setup page,
that email was sent correctly.
I use outlook XP and have 2 other email accounts
configured. These email accounts work fine. Any ideas?
Email me at firstname.lastname@example.org.
Do you get any error messages when sending? If not, can you turn on
diagnostic logging (see
http://support....when did i read an email???
is there a way to findout when I read a particular email.
I know I can view the header to see when it was sent/received.
Is there anyway to learn when (date/time) of when I actually click on it and
(changed it to read)?????
This is huge, I really hope that someone can help me.
It is easy: in the messages list, click to the flag twice (flag will red
after the first click, and flag will "complete" after second click).
After that, in the message view you'll see below the "From" and above
the "To" field:
C...sending under one email adress
a little example. I have 2 users Max and John. Now i want that both send
email but in the sender line of the message should appear email@example.com.
How can I realize that with Exchange 2000?
Create your support mailbox and grant them access. Get them to use the From
field in Outlook, and choose the support mailbox.
For Exchange news, links and tips, check:
"ltr" <firstname.lastname@example.org> wrote in message
> a little example. I have 2 users Max and John. Now i wan...freezing formatting
I would like to be able to "freeze" the formatting for the number of decimal places in cells - some will need to be integers, some will need three decimal places, etc. The problem comes when I paste in information; the number of decimal places I have formatted the cell for is overridden by the pasted-in data. Any ideas?
On Fri, 24 Oct 2003 13:31:05 -0700, "H"
>I would like to be able to "freeze" the formatting for the number of decimal places in cells - some will need to be integers, some will need three de...Question about format of reply and format of message
I have two questions about OL2003:
1. Word is set as default editor. In replying message, sometimes I will get
extra lines on hitting Enter. It makes more space between paragraphs. Is
there any way to insert one line with one Enter?
2. I'd like to have special effect in replying text message sometimes, such
as change color of font, but it cannot be done unless changing the message
format to be rich text or HTML. If I uncheck Word as default editor, there
is an option in menu. What is it about with Word as editor?
1 - Check the paragraph spacing settings e...How can I find out who has read my emails?
I have work cooegues who can access my inbox and view my emails. How can I
find out who has viewed what?
On Sat, 8 May 2010 05:04:01 -0700, Dean <Dean
>I have work cooegues who can access my inbox and view my emails.
How? They know your password?
>How can I find out who has viewed what?
That depends on a number of factors, but really in short, you can't.
Unless you have access to the server logs, which chances are you
To reply via e-mail, remove The Obvious and .invalid from my e-mail address.
First off...Change default email domain name in 5.5
The company I work for is changing its name and I have been tasked to change
the Exchange 5.5 servers' default email domain name. We currently receive
mail at three addresses, oldname.com, newname.com and mail.oldname.com. The
server was originally built on oldname.com. As such, whenever email is sent
from the server, the reply to address is oldname.com. How do I change this
to newname.com? We only have around 40 or so recipients so manually
changing the default smtp info is no big deal. Is there a MS tech bulletin
on how to do this?
Thanks for any and all help
In the propert...Negative number formatting
Hi everyone, does anyone know how to do this? I hve a column of figures
some positive and some negative. I want to format them so taht th
negative numbers are expressed in (brackets) and also so that th
column itself is decimal aligned, so even if I don't use decimal place
the brackets "stick out". I know Word does this in tables, but I can'
seem to make Excel do it. Help! Thanks, Vicky. :confused
VickyJones's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2448
How can I "enforce" a format in a cell in excel so that it allows number
entry only, i.e. it does not allow letters or any other characters.
Thanks in advance.
Data Validation; custom formula; If active cell is A1, use this:
"Elfey1001" <Elfey1001@discussions.microsoft.com> wrote in message
> How can I "enforce" a format in a cell in excel so that it allows number
> entry only, i.e. it does not allow letters or any other characters.
> Thanks in advance.
> Kei...Format Smartlist field
Is it possible to format a smartlist field? Let's say from 2 decimals to 4
This is only possible in SmartList Builder SmartLists, not in the 'out of
the box' SmartLists. In SmartList Builder, you can click on the Display
Name of a field, then click the blue arrow in the header to go to Set Field
Options. For number fields there will be a tab called Decimal Places.
Dynamics GP MVP
Flexible Solutions, Inc.
"Smokyduck" <Smokyduck@discussions.microsoft.com> wrote in message
news:98223149-4092-484D-886D-F03A319319E...Allowing third party program to send emails
Can anyone tell me how to allow a third party program to send emails via
exchange server 2003. I have a Electronic time card program (attendance
enterprise) that can send email reports out daily, but when I set it up, it
sees the global address book, but will not send emails. I am told from the
software maker that the program is not allowed to send emails via exchange
server 2003 because of new security. I want to allow this program to send
emails. Is there a way to allow this program to send emails?
On Mon, 31 Oct 2005 13:49:21 -0800, GlennM
<GlennM@discussions.microsoft.c...Export my email accounts in Outlook 2003
How do I export [backup] my email accouns in Outlook 2003?
I format my PC about twice a year & at the moment [& with previous versions of Outlook] I've had to import my [already saved] email account settings into Outlook Express & then let Outlook imort them from Outlook Express.
Isn't there a way to imort & export my emial account settings without using Outlook Express?
...Changes to Data on a Worksheet
I have a data entry sheet (Excel 2000) and a "store" sheet. The info
on the data entry sheet is saved on a single row in the store sheet. I
need to detect whether any changes have been made to the details on
the data entry page and currently do this by concatenating every data
cell on the data sheet and comparing it to the concatenated cells on
the corresponding row in the store. Is there an easier way to detect
whether any changes have been made on the data entry page?
Thanks for any help.
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "H...display multiplte email addresses and inboxes just like thunderbi
I am trying to convert from Thunderbird to Outlook. I want to have my three
email accounts (different addresses) displayed at the same time. I also would
like to have three separate inboxes like Thunderbird. Any help?
Seperate inboxes / default folders is an option in Outlook 2007, you can
have as many email accounts as you like, available all the time
"Brian" <Brian@discussions.microsoft.com> wrote in message
>I am trying to convert from Thunderbird to Outlook. I want to have my three
> email accounts (diff...Conditional Formating Help
I wonder if anyone could help me, I am after code for the following.
cell e6 = Keys Sent
Column f6 = Keys due
Column g6 = Keys received
What I want the script to do is if there is no value in g6 and todays date
is greater then the date stated in F6, then the cell turns red (prompt to
inform me that keys are late).
Use a CF formula of
"housinglad" <email@example.com> wrote in message
...ADC changing display name of an inbox
I have the ADC up and running as i am in the middle of a migration to 2003
exchange. i need to chagne the alias anddisplay name a user because her last
name changed. I renamed the account in ADUC, changed the Display name and the
Alias, but when i send an email locally or to the net it still shows her old
last name. Her inbox and user account are on the AD domain, so i cant
understand if i rename the accoutn change the display and alias why when i
send an email it still shows her original last name.
Do i need to make this change on the 5.5 server?
Have you tri...Outlook 2003 unresponsive when viewing messages in HTML format.
About two weeks ago, I started Outlook and went in to view
messages. On some messages, Outlook would appear to lock
up and my harddrive light would come on continuously for a
minute or more. The body of the message would appear as
an empty window.
We have discovered that the problem only occurs for email
messages that are in HTML format. I can prevent the
problem by going to: Tools > Options > Email Options and
checking "Read all standard mail in plain text". When I
have this option turned on, I can see a plain text version
of the message. Unfortunately, much of ...Select Case Conditional Formatting Sub?
I've tried to use the Sub below (Posted by Julie D I think) as a work around
for more than three conditional formats and it works great IF I enter the
data directly in the target cells. But, if the taget range is populated by a
formula the color changes do not occur. Is there a way to modify this to
work when the cells in the target range are formula driven? (Or, maybe I'm
doing something wrong, any ideas?)
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Range("B6:B10")) Is Nothing...Attach a file to bulk email
Does anyone know if it is possible to attach a .pdf file to a bulk email?
Probably the best way is to include a link in your e-mail template that
points to your .pdf on the web.
Larry Lentz [CRM MVP]
MCSE+I, MCSE W2K, MCDBA, MCSA Messaging
Lentz Computer Services
Microsoft Small Business Specialist
San Antonio, Texas
"Tiffany at Applewood" <Tiffany at Applewood@discussions.microsoft.com>
wrote in message news:9CD34C11-3705-43CD-872F-E3B0308F5AF7@microsoft.com...
> Does anyone know if it is possible to at...Attachment removed from forwarded email
Outlook is removing pdf and .doc attachments from emails
that others forward to me. If those same attachments are
sent direct from the sender (not forwarded from someone
else) the attachment is successfully received by
Outlook. Is there some security feature in Outlook I
need to turn off to keep it from stripping the forwarded
Are you seeing any messages about attachments at all? It's unlikely to be
your Outlook from what I can see - more likely to do with the sender doing
the forward. In their sent items, do they see the attachments?
> Outlook is re...