|
Problem with language and dates in Excel on a Mac
Hi,
I've got a problem with excel for Mac - I've tried absolutely
everything I can think of and can't seem to fix it...
The basic problem is that dates appear in french (specifically, the
month name). This is despite the fact that I've set every preference I
can find to "English".
So 10/07/2006 turns into 10-juil-2006 instead of 10-july-2006.
If I look in the language preferences i...
|
1 |
11.09.2006 15:50:54 |
|
|
embbed excel charts in word
hi
i have embedded an excel chart into my word document. i did this
through inserting->object->create from file and picking the excel
file i wanted. this embedded the chart i wanted fine. the problem is
the when i move bits of the chart.
i want to move the legend so that it is in the graph area and not at
the side. when i have the embedded chart active (you see the worksheet
ta...
|
1 |
11.09.2006 13:55:54 |
|
|
Rounding problem
I have a series of 16 and 18 digit numbers that I am trying to store and work
with.
If for example I have the number 1234123412341234 and I leave the field
unformatted I get '1.23412E+15' which is fine. If I change the cell
formatting to 'number' w/o decimals I get '1234123412341230'. What has
happened to my last '4'? Why is it now a cheeky '0'? This seems to happen
with all digits af...
|
2 |
11.09.2006 12:54:02 |
|
|
First Positive
I am trying to obtain the value of the first positive in a column to place
in a summary location.
The column starts with negative values.
I would appreciate help with this question
David
...
|
5 |
11.09.2006 12:28:33 |
|
|
Rounding problem
I have a series of 16 and 18 digit numbers that I am trying to store and work
with.
If for example I have the number 1234123412341234 and I leave the field
unformatted I get '1.23412E+15' which is fine. If I change the cell
formatting to 'number' w/o decimals I get '1234123412341230'. What has
happened to my last '4'? Why is it now a cheeky '0'? This seems to happen
with all digits af...
|
3 |
11.09.2006 12:16:07 |
|
|
Application-defined or object-defined error
Hi,
I find myself stumped by an incredibly easy piece of code and one that I
have used before.
I am getting the error:
Run-time error '1004':
Application-defined or object-defined error
I am getting the error when I run the following code:
Private Sub Workbook_Open()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
Workbooks.Open
"\\depot02\rel\ww...
|
2 |
11.09.2006 10:12:17 |
|
|
macro disabled permanently
Greetings,
I interrupted a macro I wrote that went into infinite loop by hitting
ESC. I fixed the macro function which is tied to "Worksheet_Change".
Now it never gets triggered. I put break points in code; not executed
at all. I close/open excel and respond to security dialog as "enable
macros", still not working.
I don't know what happened but code never gets executed. I don't know
wh...
|
2 |
11.09.2006 08:44:07 |
|
|
Exracting numerical data.
Sorry, I recently mistakenly posted this to excel.charting.
I recently had to extract the numerical data from text in
the cells of a fairly long column. Since my problem was
something I don't expect to have to do frequently, I simply
copied the column to Word and used its wild-cards in Replace
instead of Excel 2002's pitifully small list.
I know there are available add-in user functi...
|
9 |
11.09.2006 08:20:52 |
|
|
Newbie help question (date and time)
I want to add a couple of commands to a custom toolbar that I have
made. I want to add a button to insert the current date in the active
cell and another to insert the current time in the active cell. My
problem is I can't find ANY commands on any toolbar that does those
tasks. I know how to add existing commands to toolbars.
I am aware of the keyboard shortcuts to do those things <ctrl-...
|
3 |
11.09.2006 08:00:04 |
|
|
unable to open excel file
I cannot open an excel file on the network, an error occur that
"filename.xls cannot be accessed.The file may be read-only,or you may be
trying to access a read-only location.Or, the server the document is stored
on may not be responding"
The excel file was not a read only and I can access other on the network.I
used excel 97 SR-2. I already try to open the file on excel 2000 SR-3.
Pl...
|
1 |
11.09.2006 07:48:32 |
|
|
display order of worksheets
I would like to have multiple worksheets in the same book displayed in
a predetermined order whichever worksheet I work on. How can I do this?
...
|
5 |
11.09.2006 07:36:01 |
|
|
autofilter help
when i set my auto filter it stops at blank lines rather than allowing me to
select "blanks or non blanks"
the data that it filters doesnt pass the blank line so i have
dispatched
arrived
arrived
dispatched
when i set the auto filter to show "arrived" it still shows the second
"dispatched" because it is after the blank line
is there some setting causing this...
|
4 |
11.09.2006 06:54:58 |
|
|
Using a worksheet value within a macro - please help me
need the formula to obtain the value of Sheet : Sheet1 Cell: A23, the
value is being used to create an end total in `sheet2`
how do I input so that this value is reflected as myNum
is it
Activate.Worksheet:"Sheet1",A23 or ?????
counter = 0
myNum = ??? " need the formula here to collect value from worksheet
a = counter
Do While myNum > a
myNum = myNum ...
|
4 |
10.09.2006 23:34:41 |
|
|
Viewing a file before it is open
There is an option under File, Open called preview. Yet I can not view any
excel files. It always shows "Preview not available" Is there a setting
that I need to change to be able to do this?...
|
3 |
10.09.2006 18:56:08 |
|
|
scaling background picture
Hi,
In order to fill out a form with excel, I made a scan (jpg) of this A4-form
and put it as a background in my worksheet.
I have tried to have the cells in the right position, but it never worked
out fine.
Does anyone know how to scale or format the scan to have it real size in my
excel worksheet?
Thanks in advance,
John
...
|
1 |
10.09.2006 18:26:18 |
|
|
Sizing clip art
I would like to insert clip art into a into cells that is already the size I
want them to be. How can I get it to fit? I am having to manually resize
every time....
|
4 |
10.09.2006 16:38:45 |
|
|
compare data
Hi everybody , maybe somebody can help me
I need compare two collumn in excel / numbers /
f.e:
A B
11111 11111
11112 11113
11115 11115
05755 05755
02356 02356
I need get results for exsamle :numbers in collumn C , which is
in both collumn / A,B /
maybe it is posiible to give another result in collumn D - numbers
which are ...
|
5 |
10.09.2006 15:50:08 |
|
|
Sparklines for Excel
Hi NG,
Sparklines are tiny charts, a new invention of the info design guru Edward
Tufte. You might be interested to check out our sparkline implementation for
Excel:
http://www.bonavistasystems.com/Products_SparkLiner_Overview.html
MicroCharts enhances your Excel chart library with sparklines, bullet graphs
and other in-cell charts:
http://www.bonavistasystems.com/ChartGallery%20Colu...
|
1 |
10.09.2006 11:36:42 |
|
|
Adding Colums from yesterday
I have created a daily report to track revenue and marketing
information. This report includes columns titlted
Today Month to Date Year to Date
Is there a formula that will automatically add the "Today" column to
yesterday "Month to Date" and "Year to Date" columns bringing the MTD
and YTD columns current.
Thanks
David Hopper...
|
2 |
10.09.2006 08:29:04 |
|
|
xl 2000 - changing chart colour doesn't update legend colour
Hi :)
If I change the colour of one of, say, the bars in a chart, by double
clicking on it, the colour of the legend doesn't change. But if I change
the legend colour, the chart does.
Huh ?? What am I doing wrong ??
Thanks...
|
3 |
10.09.2006 08:25:56 |
|
|
Navigation question for Excel97
I have my spreadsheet set up to move one cell to the right when I hit
'Enter'. What I would like to do is as follows: On entering column F,
I want the cursor to move to column A of the next row. Thanks. :)
--
Zilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~...
|
4 |
10.09.2006 02:49:55 |
|
|
Excel - e-mail font
I've asked this question 3 times now in the past year and every time I get a
response from an "expert" who gives me a canned answer without really reading
my question. Here goes again.
I have Office 2000. I use Outlook not Outlook Express. I have the default
font set in Excel, Word and Outlook to Century Gothic. However, when I
intitiate an e-mail from inside Excel (File - Send to...
|
6 |
09.09.2006 23:09:27 |
|
|
autocomplete (like Access)
Hi,
I'm trying to restrict the entry of data into cells based on values in a
list.
What I need is similar to Data Validation but I want Excel to complete
the entry after the user has entered just the first character.
For example, In Microsoft Access, when creating a new table in Design
view, first you enter the field name, then tab across to Data Type.
Entering a "c" and then tab auto...
|
2 |
09.09.2006 22:58:15 |
|
|
Looping through records
Hi, I am learning some basic VBA in Excel. I know that using inout boxes
is not the best way to input multiple cells, but as I said I am playing with
VBA.
The following code takes me through cells on a single row and allows me to
enter some data.
What I cannot work out is having enjtered data into H7 , how do I then
switch to A8 and start the code again.
Would appreciate some help...
|
2 |
09.09.2006 20:54:27 |
|
|
find and delete 2 rows
Worksheet1 (names list)
Column A column B
NameA 1
NameB 2
I have managed below by worksheet1 change event and I intend
to use sheet2 / columnB as a validation list somewhere else to
speed up data entering- hate using mouse.
Couldn't manage to update sheet2 when a name is deleted on sheet1.
Don't know the usage of formulas in event codes.Any ...
|
9 |
09.09.2006 19:02:01 |