Enter numeric as text in Excel worksheet should not create error
 

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 "I
Agree" 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 "I Agree" in the message pane.

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

Enter numeric as text in Excel worksheet should not create error
 

Tools -- Options -- Error Checking Tab

Uncheck the box called "Number Stored as Text"

HTH,
Elkar


"evansight" wrote:

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 "I
Agree" 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 "I Agree" in the message pane.

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