| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentages in Excel
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expressing percentages in Excel | Excel Discussion (Misc queries) | |||
| How do I get excel to add or subtract percentages? | Excel Discussion (Misc queries) | |||
| Percentages in Excel | Excel Discussion (Misc queries) | |||
| How do i work out percentages using excel? | Excel Discussion (Misc queries) | |||
| Excel percentages greater than 99% | Excel Discussion (Misc queries) | |||
Threaded Mode
