Re: Issues with AVERAGE function
- From: CyberTaz <onlygeneraltaz1@xxxxxxxxxxxx>
- Date: Thu, 10 Jul 2008 06:44:01 -0400
"Mac" has nothing to do with it [and please avoid the all upper case - that
means something else:-)].
Are these workbooks from an earlier version of Excel? If so, the problem is
that the number system doesn't support leading zeroes in values so neither
did Excel - Mac or PC. In order to display them the cells probably were
formatted as Text. As a result their content is returning the error.
Later versions of the program will display the leading zeroes for decimal
values, but the formatting may still be set to something other than a value
format. The entries may also have included an ' at the beginning to force
the 0 to display, or it's also been seen that the letter O was used instead
of a zero:-)
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 7/9/08 8:42 PM, in article 59b53b6a.-1@xxxxxxxxxxxxxxxxxxxxxxx,
"dkskcc@xxxxxxxxxxxxxxxx" <dkskcc@xxxxxxxxxxxxxxxx> wrote:
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I'm having trouble doing simple functions such as the average and sum
functions with numbers that begin with a zero such as 0.09867, 0.09786.... I
know that there must be a simple solution to this error but I'm stuck! Each
time I do it, I get the #DIV/0 error which makes no sense as I am not dividing
by zero!
When I repeat the function using simpler numbers I get the AVERAGE function to
work just fine. Is there something in my preferences that I need to change?
This is my first time using a MAC - I have always been a PC man. I don't know
where to start.
Thanks for any help!
.
- References:
- Issues with AVERAGE function
- From: dkskcc
- Issues with AVERAGE function
- Prev by Date: Re: How can I create a macro in Excel 2008
- Next by Date: Re: How do I create an Excel formula with multiple options for the results?
- Previous by thread: Issues with AVERAGE function
- Next by thread: Text not appearing in cells
- Index(es):
Relevant Pages
|
