Number Formatting

  • Thread starter Thread starter Hawk
  • Start date Start date
H

Hawk

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
 
The only way would be to format the cell as text before an entry is made,
but then you number would be treated as text.
 
Don't know how important the numerical display is to you, and I don't know
what's involved in your math calculations, but what you could do is *try*
some of your math formulas on the "text" numbers.
You'd be surprised how much math will still work with these "numbers".

For example, A1:A5 are text and display 1:5 respectiveley.
=Sum(A1:A5) will equal 0.
However,
=A1+A2+A3+A4+A5 will equal 15.

=A2*A3/A4 will equal 1.5

=IF(A2>A1,A5*A4,A1+A2) will equal 20
AND, if you change A1 to a 2, the above formula yields 4.

All this while Column A is formatted as text.

So you see, some procedures will force the text to be converted and
calculated.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Wow...good info. My calcs are simple algebraic formulas,
so it looks like breaking down the steps will work out
nicely. Thanks for taking the time to help...
 
Back
Top