View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Hank Scorpio Hank Scorpio is offline
external usenet poster
 
Posts: 103
Default Keep Leading Zero

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! *