Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 05, 07:23 PM posted to microsoft.public.excel.worksheet.functions
SueB
 
Posts: n/a
Default 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   Report Post  
Old November 22nd 05, 07:27 PM posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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   Report Post  
Old November 22nd 05, 07:35 PM posted to microsoft.public.excel.worksheet.functions
SueB
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sum top 5 numbers from the column of numbers Martin Excel Discussion (Misc queries) 1 May 23rd 05 07:32 PM
How can I change positive numbers to negative, i.e. change 50 to - godwingi Excel Discussion (Misc queries) 5 February 28th 05 05:41 PM
Averaging Numbers when 2 numbers in one cell Ourania Excel Worksheet Functions 8 January 12th 05 06:40 PM
Validating random numbers plsauditor Excel Worksheet Functions 2 January 11th 05 11:12 PM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 10:19 PM


All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017