I want to treat numbers as text without any complaints
 

The automatic field format detection is really annoying. I want to do text
manipulation techniques on numbers and excel is just working against. Why
can't I format a cell containing a number as text ? Or do I miss something ?

----------------
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...el.programming

I want to treat numbers as text without any complaints
 

FormatCellsText.

Jeff

"Stol" wrote in message
...
The automatic field format detection is really annoying. I want to do text
manipulation techniques on numbers and excel is just working against. Why
can't I format a cell containing a number as text ? Or do I miss something
?

----------------
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...el.programming

I want to treat numbers as text without any complaints
 

I'm obviously missing something here because FORMAT CELLS, TEXT will
set the cell to contain Text - which it sounds is what you want to
happen anyway!
Stol wrote:
The automatic field format detection is really annoying. I want to do text
manipulation techniques on numbers and excel is just working against. Why
can't I format a cell containing a number as text ? Or do I miss something ?

----------------
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...el.programming