Number Formatting

Giganews Newsgroups
Subject: Number Formatting
Posted by:  Hawk (hawki…
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


the cell will display


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


the cell should display


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