Copy formula down

  • Thread starter Thread starter shakey
  • Start date Start date
S

shakey

I do not see the cause of the problem.

For these entries;
line A B C
23 4006 200 4206
24 100 50 4256 All are formatted numbers
A&B get keyed in C is =C23+A24-B24
25 10 4266 All are formatted numbers
A&B get keyed in C is =C24+A25-B25

This formula in C gets dragged down from line 2 with no problem for about
30 lines then starts returning #VALUE "a data point in the formula is of the
wrong data type".
I checked and columns a-b-c are formatted as numbers I tried as general
then back to numbers. No luck.
What is MY error please and how do I fix it. This file was in 2003 or maybe
even one version earlier as xlm but I saved it as xlsm in Excel 2009, its
now showing (compatibility mode)
Mel
 
shakey said:
I do not see the cause of the problem.

For these entries;
line A B C
23 4006 200 4206
24 100 50 4256 All are formatted numbers
A&B get keyed in C is =C23+A24-B24
25 10 4266 All are formatted
numbers A&B get keyed in C is =C24+A25-B25

This formula in C gets dragged down from line 2 with no problem for about
30 lines then starts returning #VALUE "a data point in the formula is of
the wrong data type".
I checked and columns a-b-c are formatted as numbers I tried as general
then back to numbers. No luck.
What is MY error please and how do I fix it. This file was in 2003 or
maybe even one version earlier as xlm but I saved it as xlsm in Excel
2009, its now showing (compatibility mode)
Mel
Click to expand...
I just went back and tried on the original file XLS where C was previously
blank. Same results.
 
Possible that what looks like numbers are actually text.

Simply changing the formatting will not work.

Format all to General then copy an empty cell.

Select columns A:C and edit>paste special>add>ok>esc.


Gord Dibben MS Excel MVP
 
Thank you Gord that did the trick. Apparently something was text but I do
not understand why changing format did not fix it directly. Fixed now so
will not worry why.
Thanks again Mel
 
Back
Top