Is this a bug in Excel 97

[Hawkide]

Excel 97

Cells A1:A3 are as follows

A1: 1
A2: 2
A3: 3

The cells are formatted as text

cell B1 contains =AVERAGE(A1:A3)

Cell B1 displays DIV/0 error

If I change the format of A1:A3 to general, cell B1 still gives the error

The Average function does not calculate unless I actually retype the values in cells A1:A3.

Is this a known issue, or do I have some configurable option not set weird???

 

[GlennUK]

Changing the formatting from text to general won't change the entries in A1 A2 and A3 from being text entries to being numeric entries.

To change text entries to numeric type a 1 in an empty cell, copy it, and do a Paste Special/Multiply over the existing text entries.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

I prefer to change the data at source as Glenn has outlined, but just in case you don't want to then how about

=AVERAGE(--A1:A3) array entered using CTRL+SHIFT+ENTER

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[Hawkide]

Thanks guys...