What kind of other number?

Excel could be interpreting 09/36 as a date and give you 9/1/2036

If formatted to general would be 49919

Or if you have Transition Options enabled Excel would divide 9 by 36 and
return .25

Until you show us the other number we can only guess.


Gord Dibben MS Excel MVP



On Wed, 9 Sep 2009 14:44:01 -0700, Rlsgates
wrote:

I am trying to type this in excel but keeps defaulting to another number
please help