401k Contributions / Conversion to Quicken
After conversion from MS2008 to Quicken 2010:
All of my 401k contributions show up as pretax transfers out of my paycheck
(as they should); however, they are being included in my taxable income. I
notice that Quicken has a category _401Contrib, but if I change the transfer
category, then the deposit into my 401k account disappears. Has anyone else
come across this and figured out what to do to resolve?
> After conversion from MS2008 to Quicken 2010:
> All of my 401k contributions show up as pretax transfers out of my paycheck
> (as they should); h...Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes.
However, the drop down boxes are not typical forms. These drop dow
boxes appear to be normal cells (They contain text). When I click o
the box, a little gray box shows up w/ a down arrow to the right of th
cell. However, if you right click on the cell, there aren't an
property options that are displayed.
I was wondering if anybody had any idea what kind of drop down box thi
is. How can I edit or create one
Message posted from http://www.ExcelForum.com
It sounds like it's under Data|Validation.
chris313 wr...Pasting data from Excel
I'm not sure if I should be posting this question here or in the Excel
forum but here goes. Is it possible to copy data from multiple cells in
Excel and then paste them into multiple lines of the criteria section of an
Access query? For example, Given cells and values: A1- 1
I would like to be able to copy this data from Excel and paste it into an
Access query like : Criteria: 1
I am using Access 2002 SP3 and Exc...impossible to access the "news" from outlook 2003
I wanted to set-up my newsgroups access In outlook 2003.
I followed the documented procedure
(toolbar/standard/customize) from the help menu to add
the "News" selection to the "GO" menu. It worked but when
I exited Outlook and got back later the "news" menu
disappeared. I tried to reinstate it following the same
installation procedure but the News option is no more
available in the "toolbar/customize list".
Looks like a bug.
Has anybody faced the same issue ? Is there a workaround
to access the Newsgroup interface ?
conflicts ...How do I add vertical lines to separate columns in Outlook 2003 #2
In Outlook 2000, all columns were separated by a gray
vertical line. I can't seem to set this up in Outlook
Any help would be appreciated
ARe you using Word as the message editor?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, mschwartz asked:
| In Outlook 2000, all columns were separated by a gray
| vertical line. I can't seem to set this up in O...How to use outlook address in Excel
I have an Excel sheet which I use as an invoicing-application. I would like
to retrieve address-data from Outlook where I keep all my contact-data of my
customers. So, I want to select a customer from my Outlook contactlist when I
am writing a new invoice in Excel.
In Word, I have a macro which does this, but unfortunately the
Application.GetAddress does not work in Excel.
Can somebody help me ?
"Henny Slokker" wrote:
> I have an Excel sheet which I use as an invoicing-application. I would like
> to retrieve address-data from Outlook where I...How do I transfer Outlook 2003 to my laptop
Is this possible? I bought Office 2007 Home but it doesn't contain outlook.
Outlook is on my desktop. Desktop running windows XP on both computers.
"deborah" <firstname.lastname@example.org> wrote in message
> Is this possible? I bought Office 2007 Home but it doesn't contain
> Outlook is on my desktop. Desktop running windows XP on both computers.
Find the disk from which you installed Outlook onto your desktop and put it
in the CDROM drive of the laptop....Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing
Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
Is there still a way of accessing macros via Alt+F8?
Any suggestions appreciated.
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
> In Excel 2003 I used to be able to list all macros in a workbook by pressing
> Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
> Is there still a way of...Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout
is perfect when printing to pdf (which is how the document will mostly be
used) but the layout changes if printing direct to our printer. Is there a
way that I can ONLY allow printing to pdf from this document?
You may consider using some VBA to achieve this.
One way is to use the Workbook_BeforePrint event and specify the pdf printer
in the PrintOut method, eg:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:"
Pl...how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem
unable to select all of them other than to click on each one individually.
Is there an easy way to select all of the text boxes at once?
To select multiple objects on the sheet --
Click on one object
Hold the Ctrl key, and click on additional objects
To select all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK
Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:
Select the Commands tab...excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it
prints smaller unlike older excel program.
Also when i set the margins for a spreadsheet the left hand margin wont move
over to the edge of page like right hand side?
In Page Setup: If you are using the Scaling option to print to a certain
number of pages wide by pages tall and/or you are using the columns to repeat
at left, try:
- clearing the number of pages tall value (so that it is blank), and/or
- if you are printing to one page wide, remove the columns to repeat at left
"Peter MB" wrote:
>...query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I
tell Excel to import the data it it appears to be working but never seems to
return the data. Running the same query via msquery.exe returns the data with
no problem. Can anyone tell me what the problem is ?
...Can CRM 4.0 professional run on Windows SBS 2003?
CRM 3.0 shipped in two flavours: CRM 3.0 for Small Business Server,
and CRM 3.0 professional. Apparently, CRM 4.0 doesn't come in a "for
Small Business Server". Instead, it ships as "professional" and
Has anyone tried running CRM 4.0 on Windows Small Business Server
I'm running CRM 4.0 workgroup on SBS 2003 R2, didnt have any problems yet.
As long as you have your ReportServices right during installation, you should
> CRM 3.0 shipped in two flavours: CRM 3.0 for Smal...are scripts allowed in exchange 2003?
I used to run a few scripts in exchange 5.5, and now that
I'm upgrading to 2003 I can't find how to implement these
scripts. How do I keep using my scripts from exchange
5.5 in exchange 2003?
Can you give us a bit more information regarding your scripts? Are they VBS
accessing WMI information, batch files utilizing resource kit (reskit)
Scripting works with Exchange 2003 and Active Directory...I tinker with
VBScripts. I have also used batch scripts to manage Exchange 2000 with the
"gigi" <email@example.com> wro...how to open port in windows server 2003
i have an exchange server 2003(sp1) with windows server 2003 (sp1) the
scenarion is like that my mails are going out side through SMTP filter which
is installed on another machine in this software the only port 25 is open,
internaly my mails are working fine and i can also receive mails from another
domain like hotmail and yahoo , but problem i am facing is that from out side
of my network means if i want to check my mails from my home i am facing the
problem is that i can send mail but can not receivce mail this happend
because i am using smtp protocol for sending mails and pop3 ...Customizing Outlook 2003 toolbar
I want to customize my Outlook 2003 toolbar. I know how to add buttons, but
how do I customize the button groupings by adding the vertical slash
/separator? I can't find the separator in any of the categories/commands in
the customize dialog box.
Any help would be appreciated.
"Jim" <firstname.lastname@example.org> wrote:
>I want to customize my Outlook 2003 toolbar. I know how to add buttons, but
>how do I customize the button groupings by adding the vertical slash
>/separator? I can't find the separator in any of the categories/commands in
>the ...EXCEL FORMULA #28
I'm trying to fine a formula which would show me how much money I would
save on a mortgage if I were to pay additional principal each month--in
addition to paying the additional principal how long would it take to pay
I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this
off as soon as possible by paying additional principal each month.
There are tons of free templates at:
Maybe you'll find something you like.
> Good afternoon,
> I'm ...OLE: Excel.Application
in VB.Net, I use Excel to display results :
dim xl as new Excel.Application // creates an Excel process
// snip (putting values into cells)
xl.Visible = true
If the user closes the Excel file and then my program,
the Excel process is killed in memory, which is good.
If the user closes my program first and then the Excel file,
the Excel process remains in memory !
How can I make sure the process will be killed ?
You need to set
(and before that ensure that excel doesn't halt and ask things like "save
changes?" on quitting) somewhere in your p...Conversion error
I have a table called stats that has the following columns:
jobname, ahours, aminutes, aseconds, amilliseconds.
I need to get an average of each job ran but I need to be able to
concatenate ahours, aminutes, aseconds, amillisecons into one column.
I am trying to run a simple query:
SELECT JobName, CONVERT(NVARCHAR (100),(AVG (AHours) + ':' + AVG
(AMinutes) + ':' + AVG (ASeconds) + ':' + AVG (AMilliseconds))) AS
'Average Time' FROM stats
GROUP BY JobName
I am getting the following error:
Msg 245, Level 16, State 1, Line 1
Conversion failed whe...Going Back to 2003
How do I go back to office 2003. Too many problems with the beta
What problems do you have with the beta?
Going back can be as simple as uninstalling 2007 and reinstalling 2003,
but it is also very likely that you'll run into trouble. I'd only go
back if your problems cannot be solved.
"raymi" <email@example.com> wrote in message
> How do I go back to office 2003. Too many problems with the beta
the best way...Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering
assignment and I have added a worksheet that is basically an
automatically generated report of all the calculations.
I have set the Print Area up in such a way so that the results are
printed out in well defined pages (e.g. page 1: title page, page 2:
summary of input variables, page 3: summary of calculation results
etc). The report is arranged vertically in the worksheet, so the pages
are 'stacked' on top of each other.
It prints out fine in Excel 2000 and 2002 but I recently upgraded to
Excel 2003 and now find tha...Exchange 2003 Enterprise and several mailbox stores
Is there any limitation on how many mailbox stores in a administrative group
you can create? For now we have 4 mailbox groups and 1 public folder, when
trying to create one more Mailbox-group i get this errormsg:
This storage group alreday contains maximum number of stores allowed.
ID no: c1034a7a
I thought that Enterprise edition had no limit.
You can create up to 4 storage groups, each containing a maximum of 5
stores. Enterprise Edition has a limit of 20 stores. The 'no limit' you've
heard about probably applies to the sizes of each of t...Outlook 2003
We're on Exchange 2003 and have started rolling out Outlook 2003 in place of
In Outlook 2003 by default all folders come up grouped by day and with solid
lines between the messages. Everyone hates these "features" and has made a
point of telling me so. Yes, each individual folder can be changed back
through the user interface but that's a non-solution for 100 users that have
an average of 25 folders each plus the 50 or so public folders as well.
Is there any way to change this default behavior in Outlook 2003 so that all
folders come up without the solid lines...Word problems 2003 and 2007 version
both on my main computer and my brothers laptop word isnt working! its so
on my desktop PC i have windows xp and word 2003. after getting a virus
which stopped the internet from working i had to do a system restore - which
got rid of the virus. but when i click on word it says that "this shortcut
only applies to installed products", and when i go to word through program
files it says "this product is not installed on this user" - but there is no
setup thing i can press - will i need the disc maybe?
on my bro's laptop he got the sa...Outlook 2003 won't open in ie but outlook express does
I just upgraded my harddrive form 120 gb to 400 gb using segates disk
utility and when all was done eveything except system restore and the
read email link from ie 7 worked fine. OL express would open and run
ok but OL 2003 would not, no error just won't open. Doesnt' work in
firefox either. Have uninstalled and reinstalled Office, no luck. Have
unistalled ie7, no go either. Got system restore to work again by
diabling the service from the managment console then starting it from
the system restore tab in my computers/proporties. There seems to be
some connection from ie to outlook...