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 / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Time formatting hh:mm:ss21 May 2008 00:30 GMT6
Hi, all,
I have data downloaded from a source that provides the time
as 5-6 digits.  E.g., 94423, 132218, etc.  I want to show it
as hh:mm:ss. So: 09:44:23, 13:22:18, etc.  I've tried various
How to auto add data based on value in another column21 May 2008 00:25 GMT5
Hi, I want to automatically add data in a column depending on the value of
data in another column. For example, if column one has a value of 1,3,9 or 12
then a value of 1 is automatically entered in column 2; if column one has a
value of 2,4,7,8 or 11 then a value of 2 is ...
"Excel cannot complete this task with available resources"21 May 2008 00:24 GMT2
Occasionaly I ask Excel to bite off more than my PC can chew with a lot of
calculations on some large complex spreadsheets.
Is this a software or hardware limitation? Would multiple processors give an
improved performance, a workstation?, supercomputer?, more memory? or does
insert an extra row or collum21 May 2008 00:12 GMT2
Please send steps in order to tell me how to put in a row so column A becomes
column be and column a can be used for another set of data. It will help me a
lot if the steps are in a list and not in a paragraph. I would also be much
obliged to have these steps as quickly as can be ...
Nothing shows in formula bar!20 May 2008 23:35 GMT5
There is nothing showing in the formula bar when going to a cell with data in
it; I can see the data on the sheet, but...  The default font is automatic
(black); I have no workbook template (using default); I have not changed
Windows font in anyway; help!  Thanks!
If Statement20 May 2008 23:20 GMT4
I have written a formula IF(M15="L","X","") but I want to add to the formula
IF(T15="BA","")
Can anyone help me with this?
Thanks!
Strike-throughs and equations20 May 2008 23:09 GMT2
Hello people:
I need some advice:  When you have an equation to sum all the numbers of a
column, is there some way that when you use a strike-through (part of the
fonts), that the number that now has the strike-through can be not-included
Fill Options for 2007 Excell Chart20 May 2008 22:39 GMT5
How can I get a bar chart to have lines or hatching?  I only see the picture
or texture option.  thanks
IF-more than 7 arguments20 May 2008 22:38 GMT3
The following formula is working perfectly but I now need to add one more
test....
I need to check T14...if T14 is equal to the word "Forever" the result
should be "0" and there should not be any more testing
Adjust %'s across cells20 May 2008 22:36 GMT2
Hi all,
I have 3 cells and have a total of 100% and want to enter in a % into one
cell say 40%, from there that would leave me with 60%.  IM trying to figure
out how to change one cell and then have the 100% decrease so that I dont
Sumif cells of a certain format20 May 2008 22:31 GMT3
I want to add cells that are all fomatted with the a certain cell color.
Previously answered question20 May 2008 22:31 GMT3
I asked a question this AM and got an Email that it was answered, however I
can't find the answer.
Copy and Paste20 May 2008 22:02 GMT10
I have a master sheet that I copy to from another workbook.  Sometimes it
works fine and other times my sheet that I copy to crashes.  Any ideas why
coping and pasting could cash a crash?
Is there a way to short this substitute formula?20 May 2008 21:39 GMT3
I want to remove all periods, hyphens and comma's.  The below works but is
there a better solution?
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(K35,".","")," ",""),"-","")
Need command line to change the results in a cell from #DIV/0 to 020 May 2008 20:38 GMT4
What would be a command line to change the results in a cell from #DIV/0 to
zero?
 
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.