I have a column of dates formatted as mm/dd/yy. I want to add another column
that returns the month in two characters (i.e. 7/31/95 would return 07). I
目前分類:title (5957)
- Jan 24 Wed 2007 20:34
Formatting month values
- Jan 24 Wed 2007 20:34
multiple searches?
I have a list of 120 items that I have to search for amongst 5 list of data
on 5 different worksheets. Is there a way of searching for them all in one
- Jan 24 Wed 2007 20:34
Adding Data Information to a Chart
- Jan 24 Wed 2007 20:34
word wrap in excel
Word wrap works great for the majority of my document, but for cells
containing more text (over 10 lines or so) the word wrap does not work, and
- Jan 24 Wed 2007 20:34
how to maximize the worksheet
I am using Excel 2002. A worksheet I am working on does not fill the entire
panel. The header bar does not have any mazimize/minimize symbols on it and
- Jan 24 Wed 2007 20:34
do I need array formula or sumproduct for counting?
I'm sure something like this has been answered here before, but I haven't
found it yet after an admittedly short search...
- Jan 24 Wed 2007 20:34
When I open a workbook, how can I choose which worksheet opens?
I want to be be able to set which worksheet opens when I open a specific
workbook.
- Jan 24 Wed 2007 20:34
Have excel quot;cellquot; launch PDF viewer for stored file I have
I am trying to find how do I make a cell so as to when I click on it, It
automatically launches a stored PDF file that I have in another directory.
- Jan 24 Wed 2007 20:34
HELP with dreaded formulas...
OK...I am trying to enter a formula that is based on several
criteria....criteria that is derived from different columns of a different
- Jan 24 Wed 2007 20:34
How to activate my Microsoft 2003 system reject product key
Trying to use prodct method to activate my 2003 version of microsoft and it
will not work. Need assistant
- Jan 24 Wed 2007 20:34
Preventing errors
- Jan 24 Wed 2007 20:34
Help with Date Formula
- Jan 24 Wed 2007 20:34
office 2003 small buisness edition
My problem is I cannot save a word, excel document when I make changes. The
cursor disapears when I click on save file as, then the screen freezes.
- Jan 24 Wed 2007 20:34
Help! Formula that can Ref. hidden data amp; Populate Cells with desired text
This is the first time I have ever posted a question on the internet,
so bear with me, I will do my best to be clear and concise for anyone
- Jan 24 Wed 2007 20:34
How to save data in CSV format when a field also contains comma?
I am trying to save data in CSV format. On of the fields in my data contains
one or two commas and this field gets split into multiple columns. How can I
- Jan 24 Wed 2007 20:34
How do I find the differences in two spreadsheets
I have a large spreadsheet containing assets with costs, etc. A copy was
created and changes were made to it. I would like to find a quick way to
- Jan 24 Wed 2007 20:34
reset option buttons
I have a spreadsheet with option buttons from the control toolbox. Company
reps use this sheet to select various options to create a customer quote. Is