| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.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 |
|
#3
Posted to microsoft.public.excel.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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| treat text as blank | Excel Discussion (Misc queries) | |||
| Calculating complaints more than 10 days old | Excel Discussion (Misc queries) | |||
| Want to treat e-mail addy as text! | Excel Discussion (Misc queries) | |||
| force Excel to treat numbers as text | New Users to Excel | |||
| Find&Replace * - Is it possible to treat * as text and not wildcar | Excel Discussion (Misc queries) | |||
Linear Mode
