|
|
! by
Joe
HI there, I get an exclamation mark everytime I copy and paste formulas. Then
to remove it I click in the ! and select ignore. I need to do this many many...
|
June 20th, 2007 12:50 PM
by JLatham
|
1 |
510 |
|
|
! in Calculations by
Strata
Can anyone explain to me what the ! is used for when your calculation is
puling data from another worksheet.
e.g. =+"sheet1'!B3
Thanks Strata
|
December 14th, 2005 01:15 PM
by Jack
|
4 |
615 |
|
|
|
January 28th, 2005 08:47 PM
by Dave O
|
1 |
570 |
|
|
|
|
2 |
766 |
|
|
|
|
0 |
564 |
|
|
|
|
0 |
569 |
|
|
|
January 20th, 2006 09:53 PM
by Elkar
|
5 |
568 |
|
|
" " means in IF function by
Sorue
I'm trying to understand what does this mark mean " " in IF function (Logical
test). This has been done in many Excell worksheets but I could not find...
|
|
2 |
663 |
|
|
"#N/A" results from SUMPRODUCT by
Carpie
I have approximately 10 spreadsheets in which people from multiple locations
enter in savings data each month. There are two columns of particular
interest in...
|
|
1 |
638 |
|
|
"00098" to appear by
sphilip
when i type in 00098 & ENTER or TAB the 000 disappears & only 98 appears. How
do i get all of 00098 to appear.
we use excel 2000.
cheers
|
May 22nd, 2005 01:34 PM
by PC
|
2 |
547 |
|
|
"10th" on Excel by
Wamotoo
For the past few weeks, any time I enter the number "10",
the Excel program automatically adds "th" making it "10th".
This is also occuring on the Word...
|
|
2 |
574 |
|
|
|
|
11 |
1,192 |
|
|
"30" in a cell becomes "50" by
Melanie
When I type in 30 or use 30 in an equation, Excel automatically reads it as
50 and displays it as 50. The keyboard has been changed a couple of times.
This...
|
|
5 |
704 |
|
|
">="& by
Angel160
For some of the queries that I have posted, people have very kindly
given me the correct formulae to use. Some of these have included &
(for...
|
November 8th, 2004 02:44 PM
by
|
2 |
615 |
|
|
"A valid number is required" by
Xalam
Hi there,
I have a very strange problem on one of my users.
I've created a DOT file with fields.
Some fields are type Number with the format #.##0.
The strange...
|
|
1 |
1,529 |
|
|
|
|
2 |
564 |
|
|
"Alt - I - R" problem by
Doug
About two weeks ago when I was trying to insert a row I found that my "Alt -
I - R" function was not working. After asking around, I found this has
happened...
|
|
6 |
569 |
|
|
|
|
5 |
775 |
|
|
"Arranged" files scroll together by
Not a Happy Camper
This is driving me crazy... I often display several files at once so that I
can see different sections. Ever since I've had Excel 2003, all the
"arranged"...
|
|
0 |
484 |
|
|
"Auto-return" by
Jaytee
Question 1: If I'm entering rows of data, can I set it up at a certain column
to return to the start of the next row?
So if I have 4 columns of data, I input...
|
|
3 |
526 |