|
|
|
|
2 |
474 |
|
|
Display Leading Zeros by
Excel Boy
How do I keep Excel from truncating leading zeros in cells? For example how do I keep 0000304 from becoming 304?
( 1 2)
|
|
11 |
429 |
|
|
Who can explain this LOOKUP formula? by
Basz
I posted a question on the Excel Worksheet Functions forum the other day
and received a formula that works just fine. However, I don't understand
why it does...
|
July 31st, 2004 10:16 AM
by Basz
|
6 |
276 |
|
|
Conditional max. number by
Biff
Hi Dennis!
If the "values" are in fact numeric numbers formatted to
include the leading zeros:
=MAX(IF(A1:A6=201,B1:B6))
If the "values" are actually text...
|
July 31st, 2004 12:47 PM
by Max
|
8 |
164 |
|
|
Linking Excel Workbook to PowerPoint by
Kate
Hello,
I have a spreadsheet with several tabs of data. Each
month I have to copy and paste the data to powerpoint so
that it looks more presentable.
What I...
|
July 31st, 2004 01:51 PM
by Kate
|
0 |
459 |
|
|
Current month question by
Brandy
My data appears as such:
1/2/2004
It must stay in this format.
The information I need is how many referrals were made
only for the month of July using this...
( 1 2)
|
July 31st, 2004 06:36 PM
by JulieD
|
10 |
223 |
|
|
Linking/refreshing data across worksheets by
jennifer
This is a very basic question, but has me stumped nonetheless.
I have one worksheet which contains a list of my "master data", while several other worksheets...
|
|
4 |
286 |
|
|
Pivot Table/Chart Grouping by
Ron Rosenfeld
Well, I don't know much about Pivot Tables.
I have this data (sample):
Date PerCent
Date PerCent
Apr 2001 13%
May 2001 34%
Jun 2001 31%
Jul 2001 34%
|
|
8 |
233 |
|
|
Sorting in Dynamic PivotTable by
plumstone
I created a PivotTable with Dynamic data source. When update my database and refresh the PivotTable, it worrks. However, the data is not sorted. I do not want...
|
|
2 |
322 |
|
|
Access to Template's Linked Data Sheets by
ssmith
How do I gain access to the expense statement's linked data sheet? When I make changes to this downloaded template, are these changes automatically linked...
|
|
2 |
429 |
|
|
Import Image Problem (Invisible) by
Kendo
I have a problem on a Windows 98 OS machine whereas the imported Excel image in sketches by the user is not being displayed. If printed, the image does show...
|
|
2 |
391 |
|
|
Average by
Sugar
I want to find out, on average, how many of my clients
were successful with B5:B32 containing data.
if n= s/u/na (successful, unsuccessful, not...
|
|
8 |
194 |
|
|
Permission to use object denied. by
Shannon
I have a user on a Windows 2000 machine with user rights.
The user is also running office 97. When he opens a excel
speedsheet and Enable's Macros, he gets the...
|
|
2 |
797 |
|
|
scheduling by
morphius
please respond as to i need help in creating a formula to
calculate hours in excel for my business
-morphius
|
|
2 |
129 |
|
|
File too large by
Teresa
I have a rather large spreadsheet and need to reduce the
file size. I have compressed the pictures in the file,
but the size is not getting any smaller. It...
( 1 2)
|
|
11 |
235 |
|
|
Times to Decimal Hours by
AHM
Hi folks
Am looking to calculate hours: mins into decimal hours and am struggling
big-time. Can anyone point me to an URL that details this (I have had a
good...
|
|
2 |
173 |
|
|
Formula Problem by
DavidM
I am trying to raise a formula that gives me a sum of two
cells when there is a positive value present and the
following appears to satisfy...
( 1 2)
|
August 1st, 2004 07:39 PM
by Ragdyer
|
15 |
516 |
|
|
Word Document by
George Yorks
Am typing a document in a table format, two columns.Two
questions.
In column 1 Last Names are typed, It is a conversation
between two people. Their names are...
|
|
2 |
136 |
|
|
|
|
1 |
167 |
|
|
|
|
1 |
358 |