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 / July 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
introductions18 Jul 2006 22:45 GMT2
I hope this is the place to introduce myself. I am vircats. Hi t
everybody. I am glad to meet you. I am new here, still don't know m
way around, sorry
--
simple question on splitting cells18 Jul 2006 22:13 GMT5
How do I split a small group of cells into a number of different column
without affecting the rest of the cells on the sheet? Is this eve
possible?
I have is six rows, and I want to split the first column of all o
An Operational Problem18 Jul 2006 21:38 GMT4
Using Excel 2002, Excel will not maintain toolbar customizations and will
also not close properly.
1.  If a button is added to a toolbar, it functions properly, but when Excel
is closed and then relaunched, the new button has vanished.  Found and
Large integers in cells18 Jul 2006 21:31 GMT6
How can I make Excel show integers larger than 15 digits? I mean
without showing it in squares of 10.
123456789012345 is largest I can make fully visible by changing cell
type. After that, for example 1234567890123456 is shown as
date subtraction difficulty18 Jul 2006 18:59 GMT1
I'm trying to subtract dates, to calculate time duration.  I'm
subtracting column A from column B into column C.  Column C is
formatted 'm "mos", dd "days"' and columns A and B are formatted
'mm/dd/yy/@'  Unfortunately each of the durations is 1 month too
loading data from access in vba18 Jul 2006 18:35 GMT2
How can I load a database from an Access Application in VBA?
I tried with GetObject function, but I don't know how to get the database.
Remy
Stock Inventory18 Jul 2006 17:56 GMT2
Dear Sir,
Is it possible in Excel that by just encoding the data in receive and issue
voucher it will automatically post in STOCK CARD worksheet  and then
automatically update in the MATERIALS INVENTORY worksheet: See my sample
Create a numerical sequence in a column: From 1 to ....18 Jul 2006 17:46 GMT3
I want to automatically generate a sequence of numbers from 1 to....X without
typing them all. How?
Hiding a Zero Result18 Jul 2006 17:23 GMT5
I am adding/subtracting cells C3 to J3 along a row with the result showing
in K3. When nothing is entered K3 shows a zero which I want to hide so when
I copy down the sheet to 52 weeks I don't have a column full of zeros.
I have tried =IF(C3:J3=0," ",C3:J3) and =IF(C3:J3=" "," " ...
HELP WITH FORMULA PROBLEMS18 Jul 2006 17:23 GMT1
WHENEVER I TRY TO ADD INFORMATION TO AN EXISTING FORMULA OR CREATE A
NEW FORMULA THE FORMULA APPEARS INSTEAD OF THE REULT EXISTING FORMULAS
ALL SHOW THE RESULT HOWEVER, ALSO SOME OF THE FORMULAS ARE NOT COUNTING
THE CORRECT VALUE OR SUMMING UP TO THE CORRECT FIGURE
How can I get auto sum of column when new figures are added18 Jul 2006 17:21 GMT2
I have put in formula to total a column of figures, it has empty cells for
new items to be entered as they occur. It used to total in new items
automatically, now it will not total in new items. It is a Monthly
spreadsheet. I used" create a copy "to make blank copies to use for ...
Sharing workbook18 Jul 2006 17:19 GMT1
An excel file was shared by selecting "Tool/Share Workbook.." menu item
At the same time the folder in which the file is located is set wit
"permission" at "full control". On opening the file, the status seen i
"(read only) (shared)". How do I get rid of the "read only" status. Al
Can it do this? Don't know what its called!18 Jul 2006 16:45 GMT5
Im new to excel and was wondering about the following:
In one of the columns i have to put the same information except for the
number at the end, eg example1, example2, example3 etc.
Is there something on excel that will add what i want with the number
make the cell hyperlink to any name within it18 Jul 2006 15:23 GMT2
is it possible to make the hyperlink relevent to the text within a cell.
i.e
if the cell said paul it would email to pauls email address or if the same
cell said mark it would email to marks email address and so on.
Can you sort the worksheets in a workbook18 Jul 2006 14:23 GMT2
In my workbook I have about 70 worksheets, but I want them i
alphabetical order. Is there a quick way I can do this by selecting al
sheets and then sorting, or do I really have to go into each one and d
it manually
 
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.