Number Formatting

Giganews Newsgroups
Subject: Number Formatting
Posted by:  Hawk (hawki…@hotmail.com)
Date: Tue, 14 Oct 2003

I would like a cell to display a positive number in
EXACTLY the same way that the user types it.  I thought
that the obvious solution was to set the Number Format
to "General".  However, when the user types

32.0

the cell will display

32

The ONLY exception to the rule is that if the user were to
type a number less than 1, like

..84

the cell should display

0.84

I have struggled with this dilemma for some time now, so
if anyone has a suggestion I would be deeply indebted.  TIA

Replies