Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dealing with numbers that begin with a 0
Hello i am trying to figure out some basic sums but the forulas will not
differentiate between two numbers if one begins with a 0. in other words if i enter the number 3 in a cell it give me the same results as if i entered a 03. i need it to be able to diffentiate between the two as they are two seperate references. =SUMIF(B$3:B$16,"03",A$62:A$75) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dealing with numbers that begin with a 0
Don't enter them as a number (because they aren't; they are text
references), enter them as text. Either format the cells as text before entering the references, or precede them with an apostrophe (which will not show) -- Kind regards, Niek Otten "SueB" wrote in message ... Hello i am trying to figure out some basic sums but the forulas will not differentiate between two numbers if one begins with a 0. in other words if i enter the number 3 in a cell it give me the same results as if i entered a 03. i need it to be able to diffentiate between the two as they are two seperate references. =SUMIF(B$3:B$16,"03",A$62:A$75) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dealing with numbers that begin with a 0
Thats the problem, the people that will be using the sheet will probably
never be able to remember that. Is there any other way to get it to reference as a number? "Niek Otten" wrote: Don't enter them as a number (because they aren't; they are text references), enter them as text. Either format the cells as text before entering the references, or precede them with an apostrophe (which will not show) -- Kind regards, Niek Otten "SueB" wrote in message ... Hello i am trying to figure out some basic sums but the forulas will not differentiate between two numbers if one begins with a 0. in other words if i enter the number 3 in a cell it give me the same results as if i entered a 03. i need it to be able to diffentiate between the two as they are two seperate references. =SUMIF(B$3:B$16,"03",A$62:A$75) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |