Re: wrong number appears

Next message: DDM: "Re: Text wrap problem in cell (Excel)"
Previous message: David McRitchie: "Re: Formula result = Volatile"
In reply to: LLP: "wrong number appears"
Messages sorted by: [ date ] [ thread ]

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ron Rosenfeld (ronrosenfeld_at_nospam.org)
Date: 05/06/04

Date: Thu, 06 May 2004 14:32:22 -0400

On Thu, 6 May 2004 11:06:01 -0700, LLP <anonymous@discussions.microsoft.com>
wrote:

>When I type in the number 2, it appears at 0.02 in the spread***. I have tried to change the formatting, but that does not work. Any suggestions?

Tools/Options/Edit and DEselect Fixed Decimal Places

--ron