|
|
! 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 |
506 |
|
|
! 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 |
609 |
|
|
|
January 28th, 2005 08:47 PM
by Dave O
|
1 |
566 |
|
|
|
|
2 |
761 |
|
|
|
|
0 |
555 |
|
|
|
|
0 |
560 |
|
|
|
January 20th, 2006 09:53 PM
by Elkar
|
5 |
563 |
|
|
" " 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 |
659 |
|
|
"#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 |
630 |
|
|
"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 |
541 |
|
|
"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 |
565 |
|
|
|
|
11 |
1,186 |
|
|
"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 |
699 |
|
|
">="& 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 |
609 |
|
|
"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,518 |
|
|
|
|
2 |
555 |
|
|
"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 |
564 |
|
|
|
|
5 |
770 |
|
|
"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 |
472 |
|
|
"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 |
522 |