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 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Difference In Time27 Apr 2005 21:51 GMT6
I have one colum that has the time(hour:minute:second) and cell underneath
has a second time some seconds later.  I need to find out the difference in
time (in seconds) and place this value in a seperate cell.  The cell
underneath has a time, and I need to find the difference in ...
Pivot Table Layout Question27 Apr 2005 20:53 GMT1
I have a pivot table question.  My data fields are:  Month, Employee,
Project, Task, Hours_worked.  I make a table using Month, Employee &
Project as Rows and Sum of hours-worked as the Data.  I would like to
add a "%" column to the right of the Sum of hours-worked where the
huge file size27 Apr 2005 19:56 GMT2
i have an excel file which is 15KB in size, but after doing some formating
it becomes 15MB after saving it.
What could be wrong here?
thanks
Help With VBA Macros27 Apr 2005 19:56 GMT3
I've created a spreadsheet that, when I try to save manually as a CS
using a macro... it works, but the program that reads the CSV is no
picking up the text within the CSV because it's reading the macr
code.
Count Unique Strings27 Apr 2005 19:44 GMT4
I am trying to count "unique" items and I have tried the different
suggestions out there and itis still coming up incorrect.
What I have: (These are text values, and have to remain that way.)
00000002756
How do you remove a checkbox from an excel spreadsheet??27 Apr 2005 18:17 GMT3
II am newbie to Excel and am trying to make changes to a form that has
"checkboxes" and I would like to know how to delete them.
edit formula bar in excel 2003?27 Apr 2005 18:10 GMT1
in excel 2000 there is a edit formula button that when clicked starts the
formula and produces a edit formula bar.. I find this helpful because I put
it just below the rows I am working on and keeps me on the row I am working
on and from getting confused when selecting cells.  ...
maximum number of rows that can be coppied to clipboard27 Apr 2005 17:52 GMT4
is there a maximum number of  rows that can be copied to clipboard from a
table? using access 2002 on XP,
the 'degree' symbol27 Apr 2005 17:34 GMT20
Does anyone have a good way of getting the 'degree' symbol into a series of
cells?
Either farenheit or celcius...doesn't matter...i just want the symbol.
Dave French
how to lock a single cell?27 Apr 2005 17:11 GMT1
I want to make only few cells read only.
How?
Many THANKS
Has
V Lookup 2nd Occurrence27 Apr 2005 17:07 GMT8
I was offered a solution to the above, and I think
my son has loaded a copy of DragonBallZ over the file on a floppy.
Apologies to the helpful person who replied.
I have tried unsuccessfully to find the post on Google.
format of cell27 Apr 2005 16:13 GMT4
I am trying to type in 2-26 in a cell, I have the cell as `general` format
but it keeps jumping back to custom and giving 46413.
Is there something else I should be doing?
thanks
An easier way to get the last word from a string ?27 Apr 2005 15:54 GMT3
Is there any way extract the last word from a string than this:
=IF(ISERR(FIND(" ",TRIM(A1),1)),TRIM(A1),RIGHT(TRIM(A1),MATCH("
",(MID(TRIM(A1),LEN(TRIM(A1))-ROW(INDIRECT("1:"&LEN(TRIM(A1))))+1,1)),0)-1))
Where A1 contains the string and the above needs to be entered as an array
Couple more questions...27 Apr 2005 15:21 GMT1
ok, I'm cutting and pasting a column of numbers from a mainframe session and
dropping them into excel.  But, the numbers all change when I do it!  I have
to paste into notepad, then re-copy and then past into excel.  Any ideas?
Also, if I copy 2 columns of numbers, I'd like to be ...
How do I display the RESULT of a formula27 Apr 2005 15:18 GMT3
I enter "=1+1" in a cell.  Instead of displaying 2, what is displayed is
"=1+1" (without the quotes).  I go into microsoft help, do a search on
"display formla", it has a section "display or hide formulas", it has "switch
between displaying formulas and their values on a ...
 
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.