Fairly Easy Formula Question....
......the answer to which is eluding me!
I am using this formula =VALUE(C1&" "&A1) to return a date (month in col A
and day in col C). Can someone tell me how to modify the formula to avoid
#VALUE! being returned when col C contains an empty cell.
What exactly do you have in C1.
How is C1 formatted and what did you enter (type in) for a "month"
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
...Filter Count question
I have the following code:
.Filter = "[Status] = 'Open' AND [Source] <> 'SE Meeting'"
.FilterOn = True
Me.Label32.Caption = "PCCB Action Items"
.OrderBy = "[Group_Name], [IssueID]"
.OrderByOn = True
When I execute this on a commandbutton it returns all the open action items
not equal to SE Meeting as the source code. That works perfectly.
I have a new unbound textbox called AI_Open. Once I execute the above code,
i want some code that will count the number of open action i...Two computers, one Money file.
I want to use Money on my business laptop and my home desktop, and I want
the two to synchronize (possibly via online sync.). Does anyone know if this
is possible? Would I need to buy an additional license? Thanks.
In microsoft.public.money, Uffe Henrichsen wrote:
>I want to use Money on my business laptop and my home desktop, and I want
>the two to synchronize (possibly via online sync.). Does anyone know if this
>is possible? Would I need to buy an additional license? Thanks.
See FAQ available at http://umpmfaq.info/faq.html for information on
accessing the same dat...Money Money Money !! Agloco !!
I recently joined AGLOCO because of a friend recommended it to me. I
am now promoting it to you because I like the idea and I want you to
share in what I think will be an exciting new Internet concept.
Sign in : http://www.agloco.com/r/BBBV9253
Detailed =DDnfo : http://www.ulasbeldesi.com/agloco_en.html
AGLOCO's story is simple:
Do you realize how valuable you are? Advertisers, search providers and
online retailers are paying billions to reach you while you surf. How
much of that money are you making? NONE!
AGLOCO thinks you deserve a piece of the action.
AGLOCO collects ...Purchased Money Essentials wont install
I purchased MOney essentials and got an error that said that money was open
and wouldnt install. I paid to the 5.98 to be able to redownload for 60
days. HOw do I do this.
Same thing happened to me. I called the 800# and they helped me out after
about 30 minutes on the phone.
> I purchased MOney essentials and got an error that said that money was open
> and wouldnt install. I paid to the 5.98 to be able to redownload for 60
> days. HOw do I do this.
...money 2002 #26
I have purchased a new computer and my old one has money
2002 also installed I want to take all data on old and
put in new computer how do I do this
Locate the *.mny file and copy that to your new computer. Once you have
Money installed on the new PC then navigate to the *.mny file with Windows
Explorer and double click on the file name. That will fire up Money which
will recognise your file.
Microsoft MVP - Money
"steve Post"...money 2005 #11
Is money 2005 out and when are they going to updated their
webpage with money 2005?
Depends where you look. Some retailers are shipping others are saying 21st
MS will update the webpage when they see fit! We will just have to keep
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes http://www.microsoft.com/uk/support/money/feedback
I do not respond to any emails that I have not specifically a...Duplicate Funds in Money
I have a 401k account where I have always downloaded the information myself.
I then found out that I could have money keep the information up to date, so
I tried to create a new 401k account within on-line setup.
Originally, I had a duplicate account, but I worked through that issue. Now
I'm having a problem with duplicate funds. In my original 401k I had a fund
like the following. "Merck Common Stock" with the online one, they call it
"MRK CMMN STCK" I Just want to treat them as the same, but each time money
downloads the information, it uses the "MRK ...Microsoft Money in Australia
Currently using the last version of Microsoft Money that was released in
Australia - v14 (2004?). Noticed that future versions are not available in
Australia. The seem to be some funny compatiblity issues since I have put it
on my Vista machine... it doesn't like it when other apps are open - doesn't
let me easily switch between apps. Anyway, not important.
I like to keep current with my software so would like to upgrade to a newer
version, happy to pay full price, but I REALLY need to retain access to my
historical data. Will I be able to purchase the US version and upda...WinUSB large data question
Can we use virtual memory or file mapping view buffer for WinUSB ? How can
we send large data more than gigabytes to USB device ?
Thank for your teaching .
On 2010=E5=B9=B407=E6=9C=8805=E6=97=A5 06:23, Kid wrote:
> Can we use virtual memory or file mapping view buffer for WinUSB ? Ho=
> we send large data more than gigabytes to USB device ?
I think setting up transfer requests of this size is a bad idea;=20
instead, just set up a loop that submits the data in handy chunks.
What is the max buffer size do you suggest ?
"Si...MONEY MONEY MONEY!!!
A while back, I was browsing these newsgroups, just like you are now, and
came across an article similar to this that said you could make thousands of
CASH within weeks with only an initial investment of $6.00 (American) plus
International stamps due to users that may be outside the United States! So
I thought, "Yeah, right, this must be a scam!" But like most of us I was
curious and kept reading. It said that if you send $1.00 to each of the 6
names and addresses listed in the article, you could make thousands in a
very short period of time. You then place your own na...Problems with Money 2005
I've used Money for several years. Started using '05 about two months ago.
Two days ago I got a downloaded statement from my broker (an everyday
occurence). Money crashed. It just froze up. I had to use control alt delete
to get out. Now I have tried repairing files, restoring backups, you name it.
I finally did get a backup file that was about a month old to open and run. I
made a copy for safety. As soon as the statement was downloaded, this file
froze up. I just want to get my data back for the last month, I don't care if
I have to delete the statement. I'm afraid all...Money 2000 user guide
Can i please have some help!!! I have lost my money 2000
user guide. Does anyone know where i can get a
downloadable version of it. It would be greatly
...Question marks in reply
Once in a while a recipient of a reply indicates that
instead of the text there are only question marks. The
machine, where Outlook 2000 is installed, runs Windows 2000
SP3. When the problem shows up I run Detect an Repair and
also "sfc /scannow" command using Run. The problem
dissapears for a couple weeks and then comes back. Any ideas?
...money vs simply accounting
i've used simply accounting but never ms money, are they both similar in
function? is ms money any easier?
...Rules wizard question #3
Hi - I'd like to know how I can determine how many people in our
organization are forwarding their mail to another account. I'm not
referring to forwarding which is set up on the Exchange server - we in IT
control that... I'm referring to who may have set up forwarding in Outlook
via the rules wizard. Is there any way to determine this without visiting
every single user and checking manually (which is pretty much impossible)?
...Money Data #2
Can you access the Microsoft Money data with a report writer like Crystal
Reports or Microsoft Access to create customized reports?
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"tmc" <firstname.lastname@example.org> wrote in message
> Can you access the Microsoft Money data with a report writer like Crystal
> Reports or Microsoft Access to creat...Money 2004 Error 1335 #2
Sorry about the vague description.
Upon installation I constantly run into an error. about
45 seconds into the download from the CD. The error
message says that Error 1335 because "Money.cab" file is
corrupted, network errors, or bad CD.
Upon researching the error on microsoft.com I did
followed their techniques to correct the problem.
They were: Copy the entire disk on your local desktop,
perform a clean boot and run the setup from the local
computer and not the cd. This would rule out the bad
I then continue to receive the problem. Now this disk
a...Reinstall Money Plus problems
I have Money plus on my PC which expires in 09 Nov. I purchased a new
downloaded copy so that I can extend it to 11 Jan. I tried to install
the new copy, it started the installation and gave the message: "Money
is ready to go! To complete the installation, Press Finish.
The copy of Money is still the same i.e. still the Nov expirity date.
Do I have to unstall the current copy and reinstall or is there a way
to extend the licence please?
Here are the instructions I received from Microsoft to manually
override/register Money Plus Deluxe. Hope this helps...
"Since you already pur...Print range question
I've made a spreadsheet with several tabs.
In this sheet i've selected a certain print range so only the
information i need gets printed.
But when i try to print the sheet, or on the print preview everything
on the sheet gets printed..
I thought that only things inside the print range (visible on the
sheet with a thin line), would be printed...
Is there a way that i can define wich range only can be printed
besides the print range option?
I have made this sheet with Excel2007 and converted it to Excel2003.
Is there something gone wrong with this conversion?
I cannot reproduce this....Best Super money transfer site for you......money...money...money...money...
The best site for your information all about money http://www.supermoneytransfer.info
...Repair a Money data file? MS Money or MSN Money?
I've posted here before about trouble accessing one bank in my MS Money
setup. I'm using MS Money 07 Deluxe on a WinXP Pro SP2 computer. It's
now been well over a month since I've been able to download
transactions from this bank.
Last week, I had an online chat with a MS support rep. Unfortunately,
I had to cut the session short, after over an hour, because I had a
meeting I had to attend. And with one thing and another, I'd rather
not go through the chat again and paying for phone support is a very
Anyway, to sum up: I tried accessing the data via the ...Explorer opens Microsoft Money 2002 installation
When I do just about anything on my computer (WinXP), it
attempts to install MS Money 2002. It says to insert the
CD. Just opening 'My Computer', or anything explorer
related will result with "Please Insert the Money 2002
CD". I dont have the CD. MS Money is installed, I think
it came with the computer. If I try to uninstall Money,
it says to insert the CD. Ive looked at the CD bundle
that came with the computer, but cannot find Money
Any help would be greatly appreciated.
If Money came with the machine, you might need to contact your supplier an...Money 2006 for PPC: does it work?
I'd like to know if Money 2006 for Pocket PC works for Windows Mobile 5 (in
the download page, only stated are 2002 and 2003 ->
Another thing is: Money 2006 or Ultrasoft Moneylink? What do you advise?
Is there any place where we can check what functionalities are contained in
Money 2006 for PPC? Account register, etc...
Can anyone help?
Thanks in advance,
...Spam Question #2
This is a question about some messages I am getting from my server. It is a
general SMTP and spam question.
My boss keeps telling me - I never sent this message, but here's a message
telling me it couldn't be delivered! I am wondering if these messages are
actually being sent through our server, or somehow spoofed. Here's what makes
me think they may be spoofed:
Received: from [22.214.171.124] (helo=ilisa.com)
by host28.ipowerweb.com with esmtp (Exim 4.43)
for email@example.com; Mon, 21 Nov 2005 01:10:59 -0800