Thread
:
Percentages in Excel
View Single Post
#
5
Posted to microsoft.public.excel.misc
Allan H[_2_]
external usenet poster
Posts: 3
Percentages in Excel
Niek
Brilliant, I tried that, and it is actually =Cell("format",A1), but that is
perfect, many thanks.
"Niek Otten" wrote:
You can also test for % format using =CELL(A1,"format")
If the result starts with a P it is formatted as %
--
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
Reply With Quote
Allan H[_2_]
View Public Profile
Find all posts by Allan H[_2_]