View Single Post
  #2   Report Post  
Old November 22nd 05, 08: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.