| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting general cells format to text
I'm having a hard time converting already existing general cells into text
format. I'm trying to change it into text format so SAS will be able to recognize it. Without the "green indicator", SAS, for some reason, will treat it as a "general" cell even though I've saved it and changed the cells into text. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converting general cells format to text
Sometimes when you type a number into a cell and then change the format to
text, it does not "set in" imediately. Hit F2 and then enter on each cell and it should change it for you. Hope this helps. "junkgrrl" wrote: I'm having a hard time converting already existing general cells into text format. I'm trying to change it into text format so SAS will be able to recognize it. Without the "green indicator", SAS, for some reason, will treat it as a "general" cell even though I've saved it and changed the cells into text. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
Linear Mode
