software

How can you convert a column of formatted numbers to a column of text. I
can go into format/cells/text..but when I do I do not get the little
triangle in the cells upper left hand corner indicating a number formatted
as text.

For whatever reason...my app that uses this info will not work right unless
that little triangle is there in Excel.

Is there a way to change a whole column and get the triangle marker there in
one operations

Excel 2003

Thanks, Tim
Try this:

Select your column of numbers
lt;datagt;lt;text-to-columnsgt;
Check: Fixed Width.....Click [Next] twice
Set the column format to: Text
Click the [Finish] button

That should convert the numbers to text.

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;TimRquot; wrote:

gt; How can you convert a column of formatted numbers to a column of text. I
gt; can go into format/cells/text..but when I do I do not get the little
gt; triangle in the cells upper left hand corner indicating a number formatted
gt; as text.
gt;
gt; For whatever reason...my app that uses this info will not work right unless
gt; that little triangle is there in Excel.
gt;
gt; Is there a way to change a whole column and get the triangle marker there in
gt; one operations
gt;
gt; Excel 2003
gt;
gt; Thanks, Tim
gt;
gt;
gt;