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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
What can we use as an equivalent to "Sleep()" in vb?19 Dec 2007 10:42 GMT3
I searched through the archives and there were a few messages
discussing this but no actual syntax could be found (at least during 2
searches).
Is there any vb equivalent to "Sleep()"?
Inserting a value based on a calculation from another sheet19 Dec 2007 10:15 GMT3
I have a sheet that performs a series of calculations based on a
single value and culminating in another single value.  Also the series
of calculations is too complicated and long and numerous to do in a
single calculation.  What I have is, in another sheet, I have a range
Multiple Database Lookup19 Dec 2007 10:00 GMT2
I have a problem whereby i need to see if a worksheet exists, if it
does, pick out specific data from that sheet based on the criteria i
select.  Our industry is Furniture Frame Making so the example below
is biased to that.
Greater than 1 or 219 Dec 2007 05:06 GMT7
I have a column of numbers 1,2,3,5,6,7,8,10,11,12,14 etc.. and would
like to create a formula with an if statement that if the number in
the cell below is greater by 1 the result is x, if the number in the
cell below is greater by 2 the result is y.
@if Function with date ranges19 Dec 2007 04:29 GMT1
I am wondering how to write this formula.
If a cel A1 is a date format.  And I want to use @if to say: if A1 is
between October 15st and December 10th,  do this formula, otherwise do this
formula.
Splitting a cell19 Dec 2007 04:05 GMT6
Can a column of cells be split into two equal parts with a line in the
middle? If so, how?  I am using Excel 2000.
Template format changes19 Dec 2007 00:34 GMT2
How do I change the default formatting for "$", "%" and"," when I open a NEW
file?  When I enter a large number and select comma formatting, it gives me
two decimals, and I want none.  I would like one decimal with percent format.
Older versions of Excel allowed you to save a ...
wrting spreadsheet to csv file18 Dec 2007 21:08 GMT4
In spreadsheet I have Monitor 15" in A1.
I wrtie this spreadsheet as txt file where values
are seperated with tabular sign and after that when I edit
this file I have  "Monitor 15""". Why Excell adds this 3 """" ?
Editing Dupes18 Dec 2007 20:55 GMT1
I have a list of contacts with their job titles in one column.  Not everyone
has the same job title, but some do.  I would like to create a new list where
there is just one of each of the different titles.  could someone help me do
that?
Cell color18 Dec 2007 20:53 GMT2
I want to change the color of a cell without changing the font, size, etc or
any other formats. HOW?
how do I insert a cell value in a hyperlink formula18 Dec 2007 20:47 GMT1
I need to insert a value from another cell in the same spreadsheet say B2 to
replace nnnnnn in the following hyperlink and have tried &B2, "B2","&B2&"
!B2, =B2, nothing seems to work.  Any ideas?  Thanks in advance.
http://domweb21.bank.net/apps/ecms/CCAApp ...
A way to modify pattern applied to every other row18 Dec 2007 20:45 GMT2
Hello, I do see how to use the autoformat and List 1 to produce shading for
every other row.
Is there a way to modify the color of the shading?
Thanks very much in advance
Test for Corrupt Excel File18 Dec 2007 20:33 GMT7
We do a data import into Access from an Excel file.  The xls file is
always formatted the same way.  The import function never changes.  It
works almost always, but occasionally the import fails.
If the user copies the data from the spreadsheet into a new
Excel formats18 Dec 2007 19:20 GMT4
Problem:
changing numeric values into text vales then adding a space into the text
cell, to take the place of the"," to denote thousands, move the "$" to the
end and change the "." to a comma, ex: $1,896,230.00 once changed to a text
Need Help with an Excel Formula!18 Dec 2007 16:11 GMT9
I have been trying to work on this for a while... and I hope I can get some
help.
basically, what I am working on is a type of checker.
Here is what I have come up 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.