View Single Post
  #7   Report Post  
Gord Dibben
 
Posts: n/a
Default Numbers divide by 10 in any cell...

Ollie

It is not all that uncommon for users to check that box and set to 2 decimal
places thinking that is the setting for showing the number of decimal places
in an entered number.

i.e. enter 1234.56789 and see 1234.57

The setting for that is actually found under FormatCellsNumberNumber


Gord

On 16 Oct 2005 04:46:48 -0700, wrote:

Question is; why didn't I just look there in the first place, myself?
Sheer laziness I suppose! You get so used to computers working quickly
and accurately that when somthing goes wrong....well, you just get
angry and frustrated!
Again, thanks!
Ollie