| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel counts 2 digit numbers as 1...
Hi,
How do I get around Excel counting the first digit in 2 digit numbers, for example 10, as 1 when I have added a SUMIF<= function. Example: I have 12 different columns, each named TX1, TX2 etc. And a formula that extracts from a different tab and counts the value if it is <= (less than or equal to) the current column. When Excel reaches to columns with 2 digit numbers it starts counting the 1 in the name TX10, and the 1 in the name TX11. How do I get around this? -- Brile |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel rounding my 16/17 digit numbers | Excel Worksheet Functions | |||
| why does excel change last digit of credit card numbers to zero? | New Users to Excel | |||
| How do you display 16 digit numbers in excel ? (it keeps convert. | Excel Discussion (Misc queries) | |||
| Can I change the 15-digit limit in Excel for numbers ? | Excel Worksheet Functions | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Threaded Mode
