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


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

On Wed, 27 Dec 2006 17:10:21 -0400, "Bernard Liengme"
wrote:

You can also enter the 'number' as 'o123 (leading quote, and then right
justify it
This will still 'function' as a numeric value

I think you mean '0123, rather than 'o123.

(The number '0' will still let the value be used in calculations when
the entry's in text format (including formatting it that way by using
a leading quote mark as above), but the letter 'o' doesn't.)

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