Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
fHow to write in a formula "if a nuber s between these two numbers30 Sep 2006 14:35 GMT11
Hi I need to write a formula that chooses from 3 different values and returns
the one I want it to.
lets say I have 10, 20 & 30  in 3 different cells and the number I want it
to look at is 22.
How do I change the date format in Excell from eg 2006092630 Sep 2006 14:22 GMT2
Excell doesnt recognise the above format as a date, so I would like to change
it, however the standard date formats dont work.
DELETE ROWS FROM XLS IF THE ROW CONTAINS THE STRING30 Sep 2006 13:21 GMT1
I wanted a macro , Which would find a particular string in that row and
then delete that row.
for example in the following example i want to delete all the Rows
which contain the String "aaa","syz"......( I have about 500 words).
Goal Seek or Simultaneous equation Help30 Sep 2006 13:15 GMT1
I'm trying to solve for this simultaneous equation,
And could use some help..  I think I need a function
In Cell D4 (****) to (in this case) bring back the 8.50%,
So that it will agree with my cell D9 (the 8.50%).
excel formula30 Sep 2006 12:21 GMT2
i am trying to get a cell to say "week starting (todays date).
so i put in the following formula
="week starting"&" "&TODAY()           
however the result was
Sum within one cell30 Sep 2006 10:18 GMT1
if i want to make sum of numbers which are within one cell how it is possible ?
Weather it is possible or not?
entering emails without hyperlink creation30 Sep 2006 06:25 GMT10
I want to enter email addresses in an Excel column without creating
hyperlinks. I know how to turn them off in Word, but cannot find the same
option in Excel
No text appears in excell30 Sep 2006 06:00 GMT6
When I type in the top box or a cell no text shows up.  On one of my forms
all the text was actually omited when I opened.  What happened?
[$-409].....30 Sep 2006 05:38 GMT2
hello community
can anybody in the community please tell me what is this square bracket with
dollar symbol follow with a dash inclusive the number "409" at the front the
the custom format.........example:
" + " and " - " together30 Sep 2006 05:38 GMT3
hi community
can somebody tell me how i can get the "+" and "-" sign together ? What am I
requesting is the "ALT" + "number pad numeric"
example, if I want to display the japanese yen symbol, I would need to use
How to do a macro for IF cell b1 is < b3 turn b1 red?30 Sep 2006 04:31 GMT1
I am trying to figure out on excel if Cell B1 is < Cell B2 then I would like
to turn B2 cell words or the cell to red. how can this be done?
Alternate printg 2 Wsheets to diff printers w/out reassigning ptr30 Sep 2006 02:34 GMT1
I am trying to alternate the printing of two different worksheets to
different printers.
While I can designate the different size the each sheet calls for (one
time), I have to re-assign the needed printer each time. Am I doing something
how can I make tabs work only in the colums being used?30 Sep 2006 01:45 GMT2
Tabs move from colum to colum to the right.  But, it keeps going to right
colums.
How can I make the tabs move right only until the last colum that I am
using, then move to the next row?
Autofilter misses last line30 Sep 2006 01:37 GMT7
I have a 2075 row database that I autofilter by technical area
(i.e. Data/Filter/Autofilter on technical area column header).
The filter works fine, except no matter what technical area I select from
autofilter pulldown, the last row always displays.
Correct FORMULA NEEDED PLEASE30 Sep 2006 01:32 GMT5
I am using the following formula:
=SUM(H5:H12,G5:G12,F5:F12)*200000/M5:M12
The formula is giving me the wrong answer. Is this the correct formula? What
I am trying to achieve is continuos information for a rolling 12 months. When
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.