check percentage or whole number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to check if a user enter a percentage or a regular number into
a cell, then apply different formula to it?

Note: user will enter a huge number like 2,345,678, or 22% (of something)
 
Dave, thx..
but what if the percent entry will over 100%, or even 1000%.
do you know if there is any way to convert this 100% number to text, and
then perform a search on "%"?

Alan
 
You can convert any number to a percentage, so I don't think that's the
solution:

=text(a1,"0%")

If you're lucky, you could use something like:

=CELL("Format",A1)
or
=if(left(CELL("Format",A1),1)="P","percentage","nope")
 
Back
Top