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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Inserting a column of date automatically14 Sep 2006 14:25 GMT2
I want to chart some data on a daily basis and I started a worksheet to do
this.  The first column will show the date.
Rather than enter the date every day, I am hoping there is a way to
automatically have the date inserted into each cell in the first column,
A lot of Text Boxes!14 Sep 2006 13:38 GMT7
   I got a problem on my excel files.  Hope you may help.
   I don't know why, many of my excel files have a huge number of Text
Boxes.  It's over 50,000 and they're all empty.  As a result, it slows down
my computer.  Whenever I edit the files, it takes more than 10 seconds to
VBScript Excel formatcondition cell: syntax14 Sep 2006 12:37 GMT2
I'am working on a VBScript that fills a Excel-sheet with data from
text-files
The following code should create condition formating within a cell:
      Wiith oWorkbook.cells(Regel, cColBGCount+dicbg.Count+1)
find14 Sep 2006 10:29 GMT3
How can I setup a macro or use a function to find a column who's first cell
is called "Addresses" then move the whole column to sheet 2.
Is it possible?
Puzzled
How to sort with merged rows14 Sep 2006 09:38 GMT6
This is my delema.  I have data that I need to input.  At the same time I
would like to have a blank area below each contact so that I can add notes.  
The first problem is that when I try to sort, excel keeps saying "this
operation requires the merged cells to be identically ...
Formatting a number in a cell with text and number14 Sep 2006 09:22 GMT4
I have a cell with the following entered in it:
="Daily Average = "&E2
The value of E2 diplays with all the decimal points showing. I need to
format the value of E2 to display with no decimal points showing, such
Formula request14 Sep 2006 08:51 GMT2
I am trying to set up a formula each time the data changes in column A
without having to do it manually.
The formula would be using two other columns of data for the rows involved
with the same company.
How do I force trailing zeros in an Excel cell?14 Sep 2006 08:43 GMT8
My accounting people have set up an excel spread sheet. woth part numbers.
Many of them end in a "0". Ex; 2211.11520
and if you click on a cell with a number ending in 0 , the zero goes away on
the edit line.
If statement with dates14 Sep 2006 08:27 GMT5
I'm using Excel2003 with sp2.  I want to track expiration dates of memberships
I want to say:  If m3 is blank make N3 blank  and if M3 has a date, make N3
one year later.
How do I do this?
Formatting decimal numbers as time - no conversion to time14 Sep 2006 05:08 GMT3
I have a timesheet that's used for payroll purposes.  The sheet is about as
simple as it can get.
I would like to be able to enter the time worked for XXXXXX as a decimal
number and have it display as hours and minutes.  For example:
Odd error - "This operation requires merged cells..."14 Sep 2006 01:54 GMT3
I'm cutting data from multiple sheets and pasting it into one, using Paste
Values. This has been going OK for a while, but then when I cut data from one
of the sheets, I get the error:
This operation requires the merged cells to be identically sized.
hide ranges?14 Sep 2006 00:54 GMT1
Is there a way to make certain ranges of pages hidden so that either they
must be unlocked with a password or only certian users can view/edit them?
Excel help14 Sep 2006 00:01 GMT3
I want 5% of one cell $ amount to automatically post to another cell. Is this
possible? Or do I need to it manually and enter in the info in the new cell?
is it possible to show a cell value using IF(AND function13 Sep 2006 23:54 GMT4
I would like to show the value of Cell A1 in Cell A3 , what do I need to
replace "=A1" portion of formula
The cell format is set for numbers and there is also some conditional
formating
Fun trying to convert xls to document everyone can open!13 Sep 2006 22:26 GMT4
I have Office 2003 and created spreadsheet for class schedule that I could
use formulas, hide columns, etc. Excel seemed to have more advantages over
keeping it in MS Word.  However, not everyone has Excel so I have had fun
trying to convert it.  It is only a two page document ...
 
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.