Path: utzoo!news-server.csri.toronto.edu!rutgers!sun-barr!cs.utexas.edu!uunet!mcsun!unido!unidui!hn277pk
From: hn277pk@unidui.uni-duisburg.de (Koch)
Newsgroups: comp.windows.ms
Subject: Advanced Question on MS Excel
Summary: How to prevent Excel from interpreting "0123" as 123
Keywords: excel
Message-ID: <1991Mar11.181022.3790@unidui.uni-duisburg.de>
Date: 11 Mar 91 18:10:22 GMT
Organization: Rechenzentrum Uni-Duisburg
Lines: 19

Dear Excel experts:

maybe one of you can help me with the following problem:
I would like to put the string "0123" or even better " 0123 " into 
a field. Now using =FORMULA("0123") does not work since
Excel interprets this as =FORMULA(123). Since I must have a string
in the field =FORMULA("=""0123""") is not what I want, even if the result
looks right. I know it is possible to have such a string in a field
but so far I could figure out only the following way: Use a dialog
box with a text field and enter 0123 -- obviously this cannot be used
within macros.

Any clues ?!

Thanks in advance

Peter Koch
University of Duisburg
Germany