Dealing with numbers that begin with a 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
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?
 
pre-format or use 00000000 as many as you need for a custom format
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using wildcards with logical (IF, AND) conditional formatting 2
SUMIF with criteria "<>" & "=" 4
Help with formula 1
Modify number display 4
Dealing with blank cells 4
Add values in "P" that fall between dates "03/01/00 and 03/31/00" 6
Multiple variables to sort and sum, return values<0 with sum refer 5
Sum the number of days between dates by Month 16

Back
Top