|
|
data turned in date format when copied by
C02C04
I am using excel 2007 and encountered an interesting situation. I copied a
numeric data and paste into another cell within the same worksheet. It
appeared in...
|
April 30th, 2009 04:42 PM
by C02C04
|
2 |
85 |
|
|
How do I make a specific cell mandatory? by
soday
Can a specific cell be locked and made mandatory entry to "unlock" entry into
other cells? It will be the first piece of information entered into a...
|
|
2 |
93 |
|
|
Date entry by
Hendrix[_2_]
I actuall have two questions. I have had problems with people entering
incorrect dates. Dates like; 2-16-209, or 2-116-2009. These invalid dates
cause...
|
|
0 |
92 |
|
|
web query url returns data, but not showing by
Richard S[_2_]
I am creating a new web data source. The URL returns an html table of
data with typical Content header. The data is visible in a browser,
but it doesn't show...
|
|
0 |
101 |
|
|
|
April 30th, 2009 04:28 PM
by JLatham
|
2 |
104 |
|
|
Auto Complete not working in one column by
Lisa
I have Excel 2007. I'm entering data into 3 colums. Auto Complete is not
working for one of my colums. It was when I first started and I can't figure
out...
|
April 30th, 2009 04:26 PM
by Sheeloo
|
3 |
104 |
|
|
|
April 30th, 2009 03:42 PM
by Bob I
|
2 |
141 |
|
|
Why can't I call a range of cells 'c'? by
Jock
Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o
the ').
I can't set up one called 'c' though - I get the message: "That name is...
|
|
3 |
117 |
|
|
Clearing Print Area Outline by
DubboPete
Hi all,
Is there any way of getting rid of the print area "dots" once one has
clicked and set a print area? I want to display the worksheet to
200+ people,...
|
April 30th, 2009 03:26 PM
by Bob I
|
1 |
117 |
|
|
custom format by
Dreamstar_1961
How to format something like 744532451500 into 74-45-32-45-15-00
this so the "-" are added automaticlly
Thanks
|
|
3 |
118 |
|
|
|
|
1 |
92 |
|
|
|
|
2 |
101 |
|
|
|
|
0 |
82 |
|
|
mathmatical equation symbols by
bnjii
I just loaded MS 2007 tonight. I was excited to find the capability of
inserting equations in Word, but found that this wasn't available in Excel.
Does...
|
April 30th, 2009 11:39 AM
by bnjii
|
2 |
104 |
|
|
UNABLE TO CHANGE SHARED FILE by
vcff
Hi All
I had placed a file to be shared by 5 persons. However, only 2 persons are
able to open the file and make changes while 3 persons can only open the...
|
April 30th, 2009 11:24 AM
by vcff
|
1 |
100 |
|
|
Pivot Table - Hidden Data by
Beth
Hello
I have got a pivot table showing today's transactions by account number.
I found that say an account has three receipts for £500 then it will be laid...
|
April 30th, 2009 11:03 AM
by Beth
|
0 |
143 |
|
|
|
|
0 |
115 |
|
|
Conditional Formatting by
TheStuff2007
I'm trying to make a conditional formatting rule in Excel 2007 that makes a
row of several cells where one cell contains the text "Yes" to be formatted
to...
|
|
2 |
110 |
|
|
|
|
1 |
102 |
|
|
Q for Dana DeLouis by
M Thompson
Hi Dana, and thanks again for the following:
=MEDIAN(-400,-MIN(3 + 0.02* H9, 0.05* H9),0)
Can you elaborate on it? Math is a shortcoming for me, so I'm...
|
|
7 |
84 |