Percentages are fractions. 25% is 0.25, formatted as percentage.
So a test for <1 might be what you need, if numbers will not be smaller than 1 and percentages not greater than 100

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Allan H" <Allan wrote in message ...
|I have a worksheet in excel where a single column which can be up to 1000
| lines long contains a mixture of numbers and percentages. Depending on
| whether the figure in the column is a number or a percentage, I need to
| multiply the figure by either 1 or 100. Sounds simple, but I cant find any
| way to make excel recognise is it a real number, or is it a percentage. You
| dont seem to be able to look for the % sign, cant use ISNUMBER because both
| are seen as numbers. Can anyone help please, I am getting deperate