Help with percent formula beginner
Hi, have a cell (A1) with $39.99. I want a cell (B1) were I can vary
10%, 20% etc and have that effect (A1). So If I put in 10% A1 would be
$36.00 (percent decrease). Can you please help me out with the formula?
Also it seems like if I type in % in a cell and I delete it and type
another number and I don't want a % in there it gives it to me anyway.
Can I make this stop?
Thanks so much
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("B1")) Is Nothing Then
Wi...Is there a tutorial for using the advanced filter in Excel?
I cannot make the advanced filter command work per instructions in the help
file. Is there a tutorial that shows every keystroke in an example with
Don't know about every keystroke, but Debra Dalgliesh's tutorials are
In article <8CEC9D58-3AA2-45E9-9772-59586450C915@microsoft.com>,
"waltf" <firstname.lastname@example.org> wrote:
> I cannot make the advanced filter command work per instructions in the help
> file. Is there a tutorial that shows every keystroke in an example wi...Tutorials, where to find them?
Microsoft CRM 1.2 came with a tutorial that used a sample database. Where can
I find a tutorial for Microsoft CRM 3.0.
Rafael E. Olarte
eBusiness Solutions S.A.
...Beginner's Append Query Problem
I was trying to follow the instructions on http://www.databasedev.co.uk/reset_autonumber.html
but I couldn't choose the table to which I would have appended because
that table wasn't on the list in the Append dialog box. Why is this
and how to fix?
> I was trying to follow the instructions on http://www.databasedev.co.uk/reset_autonumber.html
> but I couldn't choose the table to which I would have appended because
> that table wasn't on the list in the Append dialog box. Why is this
> and how to fix?
-----BEGIN PGP SIGNED MESSAGE-----
...Tutorials on Access Programming
Could you guys please point me towards resources on access programming?
I'm very interested in it, and would like to know if it is possible to
achieve connectivity with SQL Server. Anyway, I'd still need the most basic
Thanks for your help,
You can find Access tutorials in Access itself or by using an internat search
Yes, Access can connect natively to SQl Server or also to virtually any
other database system via ODBC.
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for ...Beginner question: how to remove news groups?
I am trying to start Exchange2003 Server by myself, without any experience.
You are not allowed to laugh ;-D
Almost everything is up and running ok, but one thing I do not understand.
I added a NEWS feed server, which pulled several thousands of news groups.
It worked ok.
Now I had to remove that server. It went ok. But how the hell do I remove
the news groups from showing all at once? I can do it one by one, but there
must be some better way ??
...Excel tutorials for first time Mac user
Operating System: Mac OS X 10.5 (Leopard)
I'm fairly capable with M/S Office on a p.c. Just got my first Mac and feel like a total idiot. Can't find tutorial or other help info for real basic stuff--i.e. inserting a new line in an existing spreadsheet. Can anyone tell me where to go, in a nice way :)?
Thanks much and sorry for asking such a stupid question.
Try MacTopia, the official website of the Macintosh BU.
Excel Help and How-To:
Excel (and other apps) courses:
On 08/07/08 5:09, in arti...book recommendations for beginner
I'm a VB programmer and I'm fairly good at ANSI c++. I want to learn
visual c++ and from some of the reading I've done, I gathered that MFC
is the place to start.
What's a good introductory book to learn how to program with MFC? I
already know C++ and I'm fairly familiar with the internals of Windows,
messages, window classes, etc. I need something to put it all in the
MFC/ATL context. Is there a standarish text, kind of like "The C
Programming Language," for learning visual c++/MFC. I'd like to get a
book that'll give me a good grasp on the fundamen...Help for a Beginner Among Beginners
Hello, would anyone kindly point me in the general direction of
a solution to a very basic database question (I'm not even sure where
I have a small consulting company of a dozen employees, with no IT
We have info from approx 1000 clients stored in an Access 2000
which is 10MB in size. A former employee made a simple form, which we
with client info, and we just add records. The file is on a file
all 12 of us access it simultaneously. Recently, I hired a guy to
a VPN, so that employees can add data to the database while on the
Howeve...Manual for beginners -- Charts with Excel
You may find useful a training manual I wrote for making charts in
Excel. The manual is for beginners to intermediate users. [So, no VBA
and dynamic ranges and stuff]. Great for teaching college students or
self-mastering the Excel Charts facility. In any case, the book is
free at http://www.vgupta.com
...Beginner help needed with line chart
I'm in a Management Science class going through some probability and
statistics stuff. I'm trying to create a graph that imitates the one
in the book. We're using QM for Windows, but I wanted to something
simple in Excel in order to understand the problems.
I have all the data, but figuring out how to set it up in Excel is
what's killing me.
Receivers with a line drawn from point 0,20 to 40,0
CD players with a line drawn from point 60,0 to 0,20
I want the lines to originate and end on the axis themselves, excel
wants to place them in the middle of the entire...Tutorials for Outlook ?
I was recently given an HP PDA which included MS Outlook 2002. I have
never used Outlook previously and would like to be directed to any
websites that explain the functions of Outlook and how to use them. I
have found most of the functions relatively easy to work out using Help
but from reading this newsgroup it appears that there are other
functions that I have not been able to access. I would like to be able
to format phone numbers and add an extra mobile field (mobile 2)to
Contacts. Any suggestions?
http://www.slipstick.com http://outlook-tips.com http://www.google.com, etc.
-...Beginner Question Re Excel Format
Using Excel 2007 and XP.
New at this.
Have Copied to the PC's Clipboard a page of data from a financial program.
How do I setup Excel, before doing a Paste of this data, such that Excel
"knows" that I want the data to appear in csv format in Excel ?
Or, do I (or must I) just Paste it as an Excel Workbook format, and then do
a Save-As in the csv format ?
Have your tried a simple copy & paste? What happens?
Do you know about the Data | Text to Columns feature?
Can you get the other program to send data to a text file?
Sorry to answer a question wi...Beginners Question...
I got a XML file like this:
<?xml version="1.0" encoding="utf-16"?>
Now i need to set the Value of one of the <MachineName /> Elements !
How can i do this with .NET...
Good evening Oleg
I've tried to do that, but i got one Error
<...Smart Tag Tutorial?
I'm looking for a piecewise Smart Tag tutorial. I.e., one that shows
how the Shape Sheet sections are built up.
...Tutorials / Documentation on WTL
Is there any tutorials or documentation on WTL? Any books? Any links?
You will Finf this Section intresting
Visit me at http://alok.bizhat.com
"I Believe this will Help"
"Joachim" <Joachim@discussions.microsoft.com> wrote in message
> Is there any tutorials or documentation on WTL? Any books? Any links?
"Joachim" <Joachim@discussions.microsoft.com> wrote in message
I would like to simply create a line chart on an open excel sheet with the
data placed in the first 2 columns (a for x axis and b for y axis) i want to
use c# code
please respond fast
I've never used excel before. Are the courses list in the order in which I
should learn? If not which one should I start with?
Which courses list are you referring to?
Some basic Excel tutorials on-line.
Microsoft Training Courses.
Gord Dibben Excel MVP
On Thu, 4 Nov 2004 12:48:05 -0800, "Con9" <Con9@discussions.microsoft.com>
>I've never used excel before. Are the courses list in the order in which I
&...A Crystal Beginner
I am using Crystal 220.127.116.11 and have loaded the Crystal enhancements.
Now I want to do against the CRM database. What do I do?
I thought I would create a data source to the CRM SQLserver, which I
did, then connect to it through Crystal Reports. That works, but when
I drill down on the AAA_MSCRM database to choose my tables, it shows
me dbo as the only option (where did this come from??) and under
that are just a few generic tables. No CRM tables. Something's not
quite right. What am I missing?
file - log on to aps server
"KBLawson" <email@example.com> wrote in ...Earn $200 per day without a website
Tired of wasting your time & hard earned money on "intelligent"
programs which promise to make you rich overnight? Then read on,
because I am going to show you.............
How I made over $2000 in just 10 days using a ridiculously stupid
technique I stole from my own affiliate
Click the following link to see the entire procedure explained step-by-
I Got MY Own ATM. J
...Tutorial for Outlook 2003.
Where can I find a free on-line tutprial specific to Outlook 2003 Tasks? I
can't seem to find it in the MS Outlook Training pages.
It is very critical for my business to learn the basics
and the backbone of links in Excel. Are there any
tutorials or articles that gives wealth of information
about MS Excel links? (in Excel 9.0.6)
Web addresses are also welcome.
You can also post to my e-mail above.
Thank you in advance.
You have additional answers in excel.links
You have asked the same question several times in the Excel
newsgroups. Basically you are not reaching more people but
are asking the same people who may visit different newsgroups
at different times. Please stick to o...Manual, tutorial or FAQ
Is there some place on the internet where I can find a tutorial about building webforms in MS CRM, using the datagrid (and similar stuff) and the DHTML components from MS CRM?
I've got the Customization Training Kit but this only scratches the surface.
I don't think it's on MSDN of TechNet...
I've added a navbar button to the Opportunities screen and want to show a form with a datagrid on it, so the user can add accounts to a datagrid.
Is this so poorly documented or am I looking in the wrong places? At this moment I'm looking for answers in the cached files of IE......A tutorial site for beginners
I am very new to visio and I am using Visio for drawing flow charts. I can
use it for drawing basic and simple flow charts but when it comes to minor
and detailed amendments, I don't know how to do. I would like to get some
tutorials or online hints. What ar ethe best links or sites?
Rasoul Khoshravan Azar
There are some good tutorials at this link:
This posting is provided "AS IS" with no warranties, and confers no rights.
Need simple step by step tutorial to configure server and client and test
That's a pretty tall order. The deployment guide is here:
MS has TONS of documentation on their website. Little having to do with
Exchange is simple, though.
"tech" <firstname.lastname@example.org> wrote in message
> Need simple step by step tutorial to configure server and client and test