Remember Me?

#1
November 22nd 05, 07:23 PM posted to microsoft.public.excel.worksheet.functions
 SueB Posts: n/a
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
November 22nd 05, 07:27 PM posted to microsoft.public.excel.worksheet.functions
 Niek Otten Posts: n/a
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
November 22nd 05, 07:35 PM posted to microsoft.public.excel.worksheet.functions
 SueB Posts: n/a
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)

#4
November 22nd 05, 08:31 PM posted to microsoft.public.excel.worksheet.functions
 Don Guillett Posts: n/a
Dealing with numbers that begin with a 0

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Martin Excel Discussion (Misc queries) 1 May 23rd 05 07:32 PM godwingi Excel Discussion (Misc queries) 5 February 28th 05 05:41 PM Ourania Excel Worksheet Functions 8 January 12th 05 06:40 PM plsauditor Excel Worksheet Functions 2 January 11th 05 11:12 PM confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 10:19 PM

All times are GMT +1. The time now is 03:43 PM.