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 / June 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Worksheet Functions13 Jun 2005 17:21 GMT3
Can anyone PLEASE HELP me?
How do I create a formula that will add a late fee according to the date?  
Here is how the spreadsheet is setup
c=amount paid
"COUNTIF" with times13 Jun 2005 16:30 GMT1
I have three column of times formatted "13:30".  The third column is the
result of subtracting the first two.  I would like to find how many of
the values in the third column are less than one hour or "<1:00".  I
tried to use
Substitute each instance of "B"in a range  with value in Col A13 Jun 2005 16:11 GMT5
need to substitute each instance of "B" in a range B4..g24 with the value in
the Corresponding row, Col A.
Signature

Al

excel 2003 - printing multiple worsheet splits 1 printjob in 213 Jun 2005 14:47 GMT4
I've got a problem with excel 2003.
When I select some sheets to print them in 1 print job, it splits the
printjob to 2 seperate printjobs. This normaly is not a problem, but
since I want to print to pdf, pdf-printer will regerate 2 files.
Reducing the size of a woorsheet13 Jun 2005 13:06 GMT3
I have been given a sheet with 200 rows.
Rows 10 through 200 are identical.
The print area is rows 1 through 30.
I want to delete rows 31 through 200 so that it may be used in another
copy/paste vaules, not formulas13 Jun 2005 13:03 GMT5
Is there an easier way to copy and paste the values of a cell without using
notepad?  When i paste directly to new column the formulas get copied--i
only want to paste the final values...
Makes sense?
File, Edit, View etc. (pull down menus) have disappeared13 Jun 2005 12:45 GMT2
All my pull-down menus in the top have suddently disappeared and I have
no idea how nor how to get them back.
Can anybody help me?
Excel stop13 Jun 2005 12:07 GMT1
I have stop errors in stations whith office 2000, excel's whith links to
reuters or bllomberg applications.
Any idea?
How can I paste text without changing the font.13 Jun 2005 11:37 GMT3
Can I post a link or just some text I have cut from the web and have
Excel keep the default font?
how to use a VLOOKUP function in a VBA code?13 Jun 2005 09:27 GMT3
Hi
am a novice in excel...i have a excel sheet with 2 columns with around 10000
records.i have placed a  button in the excel sheet and on clicking the button
it should find all the values in the first column which doesnt have a match
Drag and drop13 Jun 2005 09:06 GMT2
I have a set of input data in (say) A2 to A4. Formula in A5 and A6 and
input data in A7 to A9. Rows 5 and 6 is hidden. Row numbers and column
headings are also hidden.
The user types data into A2 and then drags to A9, in this process he
Make Cell Look like Textbox13 Jun 2005 05:17 GMT5
I'd like to have a spreadsheet cell look like a textbox on a windows
form.  The textboxes will be perpendicular and adjacent to each other.
No cells between cells.
Essentially I'm trying to add padding to a the cell border.  So each
India's and China's Date & Time13 Jun 2005 05:04 GMT6
I need India's and China's current day and time (if it's ahead one day
or later, as well as time difference) in relation to California's
current day and time. (including daylight savings time).
I want to be able to automatically show California's current time and
auto date13 Jun 2005 01:25 GMT2
Can someone tell me how to turn off the auto date part of excel?  I need to
insert different dates but everytime I try to input a date such as 6/02,
06/02, June 02, it always changes it to 6-05, 06-05, June-05.  Any time I
try any year after 2000 it does this.
Viewers for Excel files13 Jun 2005 01:20 GMT3
Does anyone know where I can find a download of an Excel viewer that will
operate on the Windows 98 operating system?
Thanks,
JWD
 
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.