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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>
> 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
>
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

On Thu, 11 Jun 2009 18:18:29 -0700, "shakey" <(E-Mail Removed)> wrote:

>
>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
>

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> 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
>
> On Thu, 11 Jun 2009 18:18:29 -0700, "shakey" <(E-Mail Removed)> wrote:
>
>>
>>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
>>
>