Can I enter dollar amount without the $ appearing on the left side of
Ralphael, the OLD one
change the format
"Ralphael1" <email@example.com> wrote in message
> Can I enter dollar amount without the $ appearing on the left side of
> the cell?
> Ralphael, the OLD one
Sure, just format the cells as Number or Currency rather than Accounting.
Gord Dibben Excel MVP
On 6 Oct 2005 14:45:56 -0700, "Ralphael1"...Money Plus Sign In Problems
I just loaded Money Plus Deluxe onto mu XP Home. Everything loaded fine
until I'm asked to sign in with my Windows Live emaila dn password. It keeps
giving me an error message that my "email address or password is incorreCT.
I even got on the internet and signed in to my hotmail account and everything
is fine. I've been trying to figure this out for hours. I really want to
use this program but I can't even sing in to get started. please help!
Just going by the misspellings in your post, double check the spelling of
your username and password. Check CapLock...Can no longer access ActiveSync
I have a Windows 2003, SP1 server running Exchange 2003, SP 2.
ActiveSync had been working using SSL, but for some reason it no longer
does. The version of the OS and Exchange were the same before the trouble
started as they are now.
Even when inside the firewall (on the LAN) this is so. If I try it without
SSL it will work from a Windows Mobile device.
I had installed the certificate for the server on the mobile devices, which
got ActiveSync and OMA working in the first place. OMA still works using SSL.
The error message is "Your account in Microsoft Exchange Server does ...How do I automatically save an Excel Worksheet?
Anyone know if there is a way to automatically save an Excell Worksheet say
every 5 minutes? I'm not refering to Auto Recovery. I need an actual save.
Download and install the AutoSafe Add-in by Jan Karel Pieterse:
(note: Make sure you download AutoSafe.zip, not AutoSaveVBE.zip)
In article <21FD75DF-E9A1-4B25-83B3-F8CFC0C5C29A@microsoft.com>,
"Tony" <Tony@discussions.microsoft.com> wrote:
> Anyone know if there is a way to automatically save an Excell Worksheet say
> every 5 minutes? I'm not referin...What does it mean when the computer is 'archiving' automatically
My computer started archiving without my opting to do this? Is this a good
Your computer doesnt Archive, Outlook does
"missprim" <firstname.lastname@example.org> wrote in message
> My computer started archiving without my opting to do this? Is this a
I have a csv text file that I want to automatically open with column
the text file is generated from a query to a remote database, so it cannot
contain any code.
pls advise mechanism.
CSV files are just plain ascii text files. They'll never contain code.
So you could have a wrapper workbook that opens the .csv and does your
formatting or you could do it manually.
Igor Lisbaron wrote:
> I have a csv text file that I want to automatically open with column
> the text file is generated from a query to a remote database, so it cannot
> contain ...W7 no longer remembers who I am...
My W7 Home Premium has stopped remembering all of my user IDs. When I log
into various sites - banks, things like Vonage, etc. my ID no longer pops up
automatically. After I have re-entered it, it forgets again next time. Is
there an option that got reset? If so, I wonder how? TIA, Paul
"Paul H" <NoSpamphobergNoSpam@att.net> wrote in message
> My W7 Home Premium has stopped remembering all of my user IDs. When I log
> into various sites - banks, things like Vonage, etc. my ID no longer pops
>...Automatically not print rows in Excel with a zero value?
I use Excel for billing invoices.
Have over 100 items.
Never use all items.
I manually delete each row so invoice is not 3 pages long.
Don't want to show all these no value rows.
Would like to have Excel only print the rows that contain a value--so I
don't have to eliminate these rows every time I create a new invoice.
just an alternative approach, why don't you design the invoice for the
"average" number of items you have (and so it looks pretty on 1 page) and
then add rows in if you need extra ones?
i have an example invoice workbook with code that does thi...How do I get automatic completion to work for an in-cell dropdown
If I have a list of Alpha, Beta, Gamma and an in-cell dropdown, I'd like
typing 'G' to auto-select Gamma.
I'm pretty sure it was doing that at some point, but now, it does not.
This isn't supported under data|validation.
You could use A,B,G in the dropdown and then use a helper cell with a formula in
Say you put your abbreviations in A1:A3 of sheet2 and the real names in B1:B3,
then you could use:
Joseph Weisblatt wrote:
> If I have a list of Alpha, Beta, Gamma and an in-cell dropd...Emails sent out automatically
Emails went out to many of my contacts without my knowledge. Can a power
outage do this? Nothing else happened......
Blondeapache, Roswell native
Did they actually go out from your computer? Or did some SPAMMER simply
paste your name into the From box of emails that he sent out?
A common trick is for a SPAMMER to find his way into one person's address
book. Then he picks two names and sends his SPAM message to one of them
"From" the other one. And maybe he sends the message "from" you "To
Everyone You Know". The ph...Allow user to disable automatic hyperlink generation in Excel.
I would like the option of NOT having Excel or Word create a hyperlink when I
enter an e-mail address. Having to manually disable each entry as I add to a
list is a pain.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/d...Automatically hide/unhide rows
I'm a VBA newbie and have searched for an answer for how to do this, but must
be doing something wrong when I've tried other codes. I need to have rows
automatically hide or unhide based on a value in column D. If the value in
column D is Y, the row should not be hidden; if the value is N, the row
should be hidden. These values may change, so the rows need to be able to
When I've entered codes in before, I click on the tab for this worksheet,
select View Code, choose Insert Module, and then insert the code. There is
already a code i...WLMail Contact List
I do not know how to delete an individual contact entry. I have duplicate
entries where the contact has changed his address. Perhaps I should have
"edited" the original, but I didn't. In any event, there are some entries I
just want to eliminate. There must be some obvious place I'm overlooking
wherein a "delete" button is hidden.
Thanks for your help.
-- Allen Furfine
On the Menu Bar: Go | Contacts. Right click on the contact you want to
remove and delete it.
Imperial Beach, CA
"a...Hotmail, Windows Messenger and WLMail
at 5 - 6 am - this morning - no problems
Get to work @ 8:30 this morning - nothing, zero, zippo.
Cant use windows mail - messenger - nothing. It wont accept my password - i
cant reset the password - and cant use secret question - or send new password
to my secondary account.
All dead - and my secondary email account - is barely working as i can
sometimes sign in - and sometimes cant.
Is everything dead?
From the Windows Live Solution Center (WLSC)
=E2=80=9CWindows Live Hotmail is currently experiencing login issues. A =
small amount of users may receive errors when atte...No longer available for Purchase??
As of this morning, July 1, Money is still available for purchase.
Wonder when they will actually stop selling.
...How do I automatically send daily email of updated Excel workbook.
I am trying to have reports in Excel (that are udpated daily) sent
automatically in email. I want them to just be sent "behind the scenes"
without me having to create a new email, attach the file, and send daily. I
want to have this process happen automatically. They are excel reports and I
use Lotus Notes, and am looking for any help that could show me how to link
these two, or send email through Excel to a specified distribution list, on
> use Lotus Notes
And see Chip Pearsons site about OnTime
http://www...Pivot Table: Item in the dropdown that are no longer in the Data Area???
I will try to be as clear as possible...
Here is the use case
1) create a pivot table
2) change one of the items (positioned in a row) in the Data Area e.g. give
it a new name
3) after refreshing, in the drop down menu the "old" items are still
Hoe can I "clean" the list, so that I don't have a list of items to select
from, that contain items that don't exist? (very confusing...)
To eliminate the old items from the dropdowns, in Excel 2002, you can
set the MissingItemsLimit property:
Sub DeleteMissingItems20...Emails cannot add to the records automatically
I am using CRM 3.0, when I created an email activities and sent to external
client (they are using gmail) via CRM web client, I can see a email record
with GUID (CRM00030002) in the History of that contact record. When the
client reply my mail, I can receive it in my Outlook Inbox with thta GUID at
the subject line, however, I cannot find any email record which replied by
the client appended to the activities/history of the contact record, does any
has this experience and do you guus know any way to solve it?
I have a cell that reads:
What does the plus sign mean in this formula?? What will happen if I delete
just not required :-)
Simply delete it
"Christopher Anderson" <ChristopherAnderson@discussions.microsoft.com>
schrieb im Newsbeitrag
> I have a cell that reads:
> What does the plus sign mean in this formula?? What will happen if I
It usua...Automatic Send/Receive in Outlook XP
How can I set up an automatic Send/Receive in Outlook XP?
I have to manually press send/receive to receive messages.
Tools | Send/Receive Settings | Define Send/Receive Groups
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Louski" <email@example.com> wrote in message
> How can I set up an automatic Send/Receive in Outlook XP?
> I have to manually press send/receive to receive m...Opening New Excel file closes the Existing One Automatically
I've got a few templates that we use in our office.
We'd frequently create standard workbooks from these templates: We had a
shortcut insid the task pane which we click to cerate a new one from the
standard template, fill it with data.
At the point JUST BEFORE IT'S BEING SAVED (or have a filename), if we open
another existing workbook (created from the same template and saved on
disk), it would open and Excel would closes the UNSAVED copy without even
prompting us to save. This is costing us a lot of time but looking inside
the macros of the template, I've not e...I need a blank open hours sign
I need a blank bussiness open hours sign that I was able to get with Windows
millinium and can not find with XP. Can you help me?
...how do i reset data automatically? #2
ok...what i need to do is add mondays total to tuesday..then tuesdays to
wednes days...and so on...then on sunday clear the workbook.but keep the
totals thru the end of the month....
n8rboy1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15775
View this thread: http://www.excelforum.com/showthread.php?threadid=273794
...how do i keep emails from opening automatically
I have just started using Microsoft Outlook and when I used Outlook Express -
there was an option that you could use so an email didn't open just by
sitting on it - you actually had to open it to mark as read
Can you do this in Microsoft Outlook?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, angela68 asked:
| I have just started using Microsoft Outlook and when I used Outloo...All of a sudden my MFC Project is no longer a MFC Project ?
I�m in the middle of a project and just wanted to add another mfc-class with
the wizard when it says: MFC classes can only be added to MFC projects.
I mean that is the way I have done it everytime and suddenly in the class
wizard it seems that I can only add a .NET class. Does anyone have an idea
how this could happen ?