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....

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....

Sorry, forgot to mention:

<Tools <Options <Edit tab,

And *UNCHECK*

"Enable Auto Percent Entry".

This custom format doesn't seem to work on versions without this option
(XL97).
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Husker87" wrote in message
...
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....

Perfect . Thanks Much. Have a good weekend.

"RagDyeR" wrote:

Sorry, forgot to mention:

<Tools <Options <Edit tab,

And *UNCHECK*

"Enable Auto Percent Entry".

This custom format doesn't seem to work on versions without this option
(XL97).
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Husker87" wrote in message
...
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....

Appreciate the feed-back.
--
Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Husker87" wrote in message
...
Perfect . Thanks Much. Have a good weekend.

"RagDyeR" wrote:

Sorry, forgot to mention:

<Tools <Options <Edit tab,

And *UNCHECK*

"Enable Auto Percent Entry".

This custom format doesn't seem to work on versions without this option
(XL97).
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Husker87" wrote in message
...
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....