| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Cell to text
When I have numbers in a cell and try to format them as text they do not all
change to text. |
|
#2
|
|||
|
|||
|
They won't change to text until you make your next change to the value.
Selecting the cell, hit F2, then enter is enough. (after you've changed the format to Text) Dawn wrote: When I have numbers in a cell and try to format them as text they do not all change to text. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
| Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Linear Mode
