Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!randvax!cave
From: cave@randvax.UUCP (Jonathan Cave)
Newsgroups: comp.windows.ms
Subject: Re: Advanced Question on MS Excel
Summary: Use the TEXT() function
Keywords: excel
Message-ID: <2927@randvax.UUCP>
Date: 19 Mar 91 16:05:16 GMT
References: <1991Mar11.181022.3790@unidui.uni-duisburg.de> <1991Mar14.172822.18763@ncsu.edu>
Reply-To: cave@randvax.UUCP (Jonathan Cave)
Organization: RAND Corp., Santa Monica, Ca.
Lines: 5


I presume you are doing this in a macro.  The function TEXT(stuff,format)
will do the trick, e.g. TEXT("0123","0"), or maybe TEXT(0123,"0").  Or
you could type it in a cell as a string (as suggested by other replies) and
fetch it with DEREF().