I made a chart that has dates on the x-axis. The dates are not in
consecutive order (ie Jan 5, Feb 8, etc). Excel defaults the axis
format such that the dates fall in consecutive order and thus, makes my
plot uneven. How do I format so that the exact dates I've entered into
the cells show up on the x axis without adding any extra dates?
software 發表在 痞客邦 留言(0) 人氣(0)
I copied my contacts from another email program and they came out as Excel
spreadsheet. The file is on my desktop.How do I get them converted and into
OUtlook???
Most likely it is a CSV file, if not open it in excel and save it as such.
software 發表在 痞客邦 留言(0) 人氣(4)
Anyone, and everyone
I have a macro to save my spreadsheet. (I am saving it several times
with diffrent names based on the data the macro pulls)
software 發表在 痞客邦 留言(0) 人氣(0)
When I filter records in Excel the number of records are not displayed on the
Status Bar. I am expecting results i.e. 5 of 50 records. All I see is
quot;Filter Modequot;. How do I correct to display 5 of 50 records??
Debra Dalgleish explains it he
software 發表在 痞客邦 留言(0) 人氣(0)
Hi everybody,
I have data such below for a year,
How do i calculate average and stdev from sample1 to sample4 on each date?.
Is there any functions or formulas to automatically calculated it ?
software 發表在 痞客邦 留言(0) 人氣(0)
060124 5pm PROBLEM: Excel Equation Function / Conditional Formatting Dropout
Having some problems with entering data. Symptom is when enter data in one
column, its mirror image was not showing up in different column (using:
=IF(J9=quot;quot;,quot;quot;,IF(LEN(J9)gt;3,AV9,UPPER(AV9)))
software 發表在 痞客邦 留言(0) 人氣(0)
I'm at my wits end! There is this cell in my spreadsheet that won't print (on
paper). Everything else around it prints. I've tried everything I can think
of to get it fixed. Retyped the cell contents; copied to it from another
cell. Nothing works. I can see the text on the screen and in print preview
but it just doesn't come out on the paper. Here is the text I'm trying to
software 發表在 痞客邦 留言(0) 人氣(0)
I have a financial application built on Excel. When I view the worksheets,
all of the column widths seem fine.
On occaison, when someone else views the same data in the worksheet, they
get the proverbial ###### showing the column is too small.
software 發表在 痞客邦 留言(0) 人氣(0)
Hello,
I searched the forums and were able to find similar things but cannot
make it work for the action that I need.
software 發表在 痞客邦 留言(0) 人氣(1)
I have attached a excel file
can someone tell me how i can sort the middel collum from old date to
new date -------------------------------------------------------------------
|Filename: sortingdates.zip |
|Download: www.excelforum.com/attachment.php?postid=4512 |
software 發表在 痞客邦 留言(0) 人氣(1)