I have a worksheet example: column A is quot;datequot;, column B is quot;workquot;, column C
is quot;amountquot;.
05/01/2006 test 24
05/01/2006 12
software 發表在 痞客邦 留言(0) 人氣(0)
I embed Calendar control in Excel 2000.
But it can't be displayed date properly in Excel 2003.
I can't see day information in each cell.
I know, it's Calendar control 11.0 in Excel 2003 and 9.0 in Excel 2000.
This is the reason, or not?
software 發表在 痞客邦 留言(0) 人氣(0)
Hi,
I'm working with an Excel file (7 MB) and I started getting this message
when I save it: quot;Excel could not save all the data and formatting you
recently added to the filequot;.
As far as I can see, the problem is in some of the formatting, and not in
software 發表在 痞客邦 留言(0) 人氣(0)
How do I add military time from one cell with minutes from another cell and
also show the change in the hours?
aka....0600 and add 60 min to make 0700....and 0635 add 35 min to make 0710
software 發表在 痞客邦 留言(0) 人氣(0)
Hi
I have a league table (attachment table named 'World Cup League'). It
updates scores as i enter them into a data table that precedes it
(titled 'Games Won'). I would like to be able to automatically sort the
software 發表在 痞客邦 留言(0) 人氣(0)
I have colored in a portion of my worksheet and this has blotted out the
gridlines. I want to put them back in. How can I do this in Excel 2002?
Thank you.
Hi!
software 發表在 痞客邦 留言(0) 人氣(0)
How can I write a formula that will count all null cells within a column, but
only if another column is also null for that row?
Situation: I am using Excel to track training of personnel for the
company.(I know, it would probably be better done in Access. Still teaching
software 發表在 痞客邦 留言(0) 人氣(0)
I want to set up a condtional formula that if I would enter a word like star
I would get a numercial result in the cell next to it like number 55, If I
type the word finsih in the same cell I would get a result 95
can this be done?
software 發表在 痞客邦 留言(0) 人氣(0)
I cant seem to acces the conditional formatting thing in the formulas pull
down.I would really like to use this feature, It just is always unavailible
If your workbook is shared, CF is unavailable. See 'Features that are
unavailable in shared workbooks' in help
software 發表在 痞客邦 留言(0) 人氣(1)
I just loaded MS Office 2003 and have found that when I attempt to open
documents (files) saved in Excel I get the following error.
Error message: Windows cannot open this file. quot;To open this file, Windows
needs to know what program created it. Windows can to online and look it up
software 發表在 痞客邦 留言(0) 人氣(5)