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 / New Users / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Beta 2 Technical Refresh29 Sep 2006 19:43 GMT2
Hi, I have just loaded the Tecnical Refresh for MS Office Beta 2, however
when I try to open any spreadsheets (predominantly MS Office 2003 versions)
they get blocked by anti virus software - presumably linked to the Technical
refresh. These spreadsheets were accessable prior to ...
i have a pps file that i cant open what do i need to open it with29 Sep 2006 19:05 GMT1
i recieved a few pitures and cant open then because they are a pps file what
do i need to open them with????
Formula Problem29 Sep 2006 19:03 GMT3
I have an excel sheet that has almost 4000 data rows.  I need to compare the
old sheet to the new sheet and if the part number is equal, I need it to
show me the discount from the old sheet in a column in the new sheet.
Here is the formula I came up with: =LOOKUP(A4,old!A4:A4000 ...
Rounding of amounts29 Sep 2006 19:02 GMT12
I have a small retail store and am currently working on price changes. I
have an excel with all the calculated prices however I would like to round
all amounts to xx.x9. The 2nd decimal should always be 9.
Is there a way to do this in Excel? I checked the help file for anything
i don't want to enter dublication data at a column29 Sep 2006 19:00 GMT1
i don't want to enter dublication data at a column
Calculate Rate of Change Formula29 Sep 2006 18:03 GMT6
Could someone help me w/the  rate of chage formula to use when going from a
Negative to a Positive number and visa versa
In the column below  - and + #s followinf each other
So what formula should I use to figure out ROC between  1 & 2, then between
Run-time error 424, Object required29 Sep 2006 16:10 GMT6
I have the following code:
sub foo()
   dim record as range
   set record = Range("A" & ActiveCell.row & ":K" & ActiveCell.row)
Excel 2003, when I click on a particular cell it gets deselected29 Sep 2006 15:41 GMT1
While using Excel 2003, when I click on a particular cell, within 30 seconds,
that particular cell gets deselected followed by the workbook. So each time I
need to click either the cell or workbook to enter data in that particular
sheet.
Replace with Macros29 Sep 2006 15:10 GMT2
I need to replace the "," by a "." in many cells to fit another country
decimal separation. My regional parameters use normally ",".
When I do it into Excel with the replace function it is ok and produce the
macro script :
How can I check a cell for current date and insert it if blank?29 Sep 2006 14:46 GMT3
I am modifying the invoice template. I want to create a formaula that checks
the date cell for the current date. If a date occupies the cell nothing
happens, otherwise, the current date is inserted. Can this be done?
Thanks
formula with letters and numbers29 Sep 2006 14:26 GMT1
Excell 2000 or Excell 2003 can a formula be set up to use letters and numbers
like V2 to record in column for v the number 2 if the input is v4 the number
would be 4 and in the same cell the combination of T3 could be entered and in
the column for t would record 3.
Compare cell contents29 Sep 2006 11:48 GMT2
I want to check if two cells do contain the same text, e.g. the same country name.
In case there is a difference I want to highlight the first cell with color red. something like
that.
I tried Conditional Formatting but it seems that the IF function only works for numbers, and not ...
Macro/Database question29 Sep 2006 10:25 GMT1
I am using a macro to connect to the database and update a stored
procedure.  I am able to disconnect the excel sheet from the database
manually by going to "data" in the menu, then "import external data",
then "data range properties", and unchecking "save query definition" in
Fx does not work?29 Sep 2006 07:36 GMT4
I have copied this formula to an other workbook, but I keep getting #NUMBER
as a message? I have copied the original several times bu cannot get it
working?
Thanks
A complete novice guide to excell which course is best to start29 Sep 2006 02:42 GMT1
Not sure which one is best to start with
Is there one for works excell which would be easier to start with
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 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.