Thanks Hank.

I posted a reply to Dave also.


Gord

On Thu, 28 Dec 2006 11:00:28 +1100, Hank Scorpio wrote:

On Wed, 27 Dec 2006 17:30:58 -0600, Dave Peterson
wrote:

I think it depends on what you do with that cell:

With '0123 in A1:
=a1+5
returns 128

=sum(a:a)
won't include 123 in that sum.

Yup, what Dave said. Though I confess that I didn't check it beyond
simple arithmetic opertations because "leading 0" typically means
telephone or credit card numbers or similar, which generally don't
have calculations performed on them. The fact that you can, in some
cases, do so is really only an aside.

Gord Dibben wrote:

My Excel 2003 does not recognize a string such as '0123 as a numeric.

Could either of you two gentlemen explain how the string as above can funtion in
calculations "as is"?

Gord

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

Gord Dibben MS Excel MVP