software

Enter numeric as text in Excel worksheet should not create error or warning.
If I specifically enter a ['] preceding the behavior as I've explicitly
stated it should be that I want this value to be treated text in the
worksheet.

Wish of the day: provide a simple way to make your spreadsheet behave with
the elegance and simplicity of Lotus 123.
--
- evansight

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

Tools --gt; Options --gt; Error Checking Tab

Uncheck the box called quot;Number Stored as Textquot;

HTH,
Elkarquot;evansightquot; wrote:

gt; Enter numeric as text in Excel worksheet should not create error or warning.
gt; If I specifically enter a ['] preceding the behavior as I've explicitly
gt; stated it should be that I want this value to be treated text in the
gt; worksheet.
gt;
gt; Wish of the day: provide a simple way to make your spreadsheet behave with
gt; the elegance and simplicity of Lotus 123.
gt; --
gt; - evansight
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc