Formatting cells

[timmyc]

Is it possible to format cells to text only, therefore when entering
number into a cell the wrong format symbol will appear. This does wor
when formatting a cell to text and entering only numbers but when yo
enter text and numbers it does not work. Is this possible?

Ti

 

[Bob Umlas]

What's a "wrong format symbol"??

 

[EdMac]

have you tried DATA > Validation and then specify what you want

Ed