Works well with the number less than 1 but maybe I'm doing something wrong...
it doesn't want to take numbers greater than 1 without the % sign. I tryed
14 and it comes up "14.0%" Any ideas? Thanks for lookng at it....
"RagDyer" wrote:
You can try this custom format:
[=1]#,###.00;[<1]#.0%;GeneraÂ*l
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Husker87" wrote in message
...
OK... here's the question. I have a cell that I input a number into. If
I
input a number less than 1, I want the cell to be formated with a
percentage
sign. If I input a number greater than 1, I want it to show just as a
number
(with no percentage sign).
I would prefer the answer NOT include a macro as this worksheet will be
used
on older computers that have a hard time running macros. If it can't be
done
without a macro then a macro will be OK. Any thoughts? and thanks very
much....
|