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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Matching problem, trying again20 Apr 2007 01:00 GMT10
I have this worksheet where I have items in the third column that
match up with items from the second column corresponding to the tenth
increment decimal numbers in the first column.  In the example below,
the first 3 numbers in the third column match up with numbers in the
Change 60 minutes to 1 hour19 Apr 2007 22:46 GMT1
I have a worksheet with a several fields that I place in minutes on
projects.
I need to total up the mintues to relect hours.
For example:
Entering Text and Date19 Apr 2007 22:22 GMT2
I need a macro that will enter some text "Uploaded" and the date and time in
this format "The text" date time such as Uploaded 04/19/07 12:42 PM. I don't
want this time to change after it is entered"
Can any one help?
Data Validation19 Apr 2007 21:48 GMT1
In excel I want to validate a cell where no more than 14 digits should be
entered. And I want another cell to be validated to be entered as text only
and any number should be restricted?
Please help me with this. Not sure how to do it.
Save19 Apr 2007 21:24 GMT2
I have a activeworkbook.save command as stated in a previous post but
I'm not quite happy with it...
Basically it takes too long to save. I'm usuing an old PC and it takes
about 3 seconds to save. However if I only have the speadsheet open
Using the EXACT Function19 Apr 2007 21:04 GMT4
I've created a simple spreadsheet.
Column A is a list of 15034 used Work Order reference numbers (many values
are missing); Column C is a complete list (25,000 numbers).
I want to get a separate list of unused numbers, but can't get the  EXACT
Exact function19 Apr 2007 20:50 GMT3
I've created a simple spreadsheet.
Column A is a list of 15,034 used Work Order reference numbers (many values
are missing);
Column C is a complete list (25,000 WO numbers).
i can't figure out how to calculate percentages in excel19 Apr 2007 20:39 GMT4
I can't seem to get excel to show my the right numbers in percent format
i'm dividing a cell of 3000 by a cell of 342 and i get 8.771929825. if i try
to switch this to percentages i get 877%.
what am i doing wrong?
Time19 Apr 2007 19:52 GMT5
I am having a problem with calculating time.  I can calculate the difference
in hours over midnight, but what I can't do is not get a value to appear
when I have only put in one number...For instance.   I put in the time I
start, and in my hours it shows midnight minus those ...
Macro to remove last 4 characters from the contents of a cell.19 Apr 2007 19:52 GMT1
We need to come up with a way to remove the last 4 characters from the
contents of a cell.  I tried a macro, but wasn't sure how to make it go to
the next cell.  For example, I select a cell, press end, backspace 4
positions and then hit enter.  Works great for 1 cell! Is there a ...
summing data on months19 Apr 2007 18:50 GMT1
I have spreadsheet, in which col A has supplier name, Col B has year,
Col C has Months and Col D has number of units supplied by the
supplier.
Now to calculate the number of units received for Month of Mar-06, i
how to append text to the end of a row19 Apr 2007 17:54 GMT1
I have to batch rename a few thousand images that are named something like
1-1234-1111-1.jpg
A program I have can rename using a csv file with 2 columns
originalname;newname
Get the list of external links19 Apr 2007 17:05 GMT1
Is there any way to get the list of external links referred by a workbook?
Normally, we get this list by using Edit->Links in Microsoft excel. But I
want to know the list of external links by programmatically.
Thanks in advance.
importing from Quatro Pro 819 Apr 2007 17:00 GMT1
I have windows xp and files in quatro pro 8 that I am trying to import into
Excel 2007 it says invalid when I try and the only converter I can find is
for windows 2000
Custom format to divide cells by 10019 Apr 2007 16:38 GMT2
Is there a way to set up a custom format that will divide numerical
data by 100?
I do not want to edit the fixed decimals option under Tools > Options
> Edit tab, as this will change all the cells in the workbook. Nor do
 
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.