Keep Leading Zero
Thanks Dave
I tested using 5 of the Functions from the AutoSum drop-down and '0123 was not a
valid numeric.
Did not realize a simple =cellref + 5 would add correctly.
Gord
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.
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
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! *
Gord Dibben MS Excel MVP
|