converting general cells format to text

junkgrrl · 01-12-2006, 11:20 AM

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?

Sloth · 01-12-2006, 01:55 PM

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?

**thosecars82** · 10-17-2012, 04:05 AM

Is there anyway to do this just once for a huge range of cells without having to do it on a one by one basis?

Thanks

**arlu1201** · 10-17-2012, 04:52 AM

thosecars82,

Its not likely that someone will reply after 6 yrs. So its better if you start a new thread for your question. You can surely link back to this thread.